|
 |
|
|
|
|
|
|
|
|
|
|
|
| v |
Suppose
a college wants a database of their
|
|
|
students,
faculty, courses taught, student transcripts,
|
|
|
and
so forth, what things should go into a design and
|
|
|
how
should it be organized?
|
|
|
|
o |
Students:
first name, last name, home address, transcript …
|
|
|
|
o |
Faculty:
first name, last name, SS#, home address, rank …
|
|
|
|
o |
Courses:
class name, number, students attending, grades …
|
|
| v |
Deciding
on the schema is called “database design”
|
|
|
and
it takes a little study to do right … but it’s easy to
|
|
|
see
the principles in action
|
|
|
|