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