Designing A Database Schema
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?
- 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 “database design” and it takes a little study to do right … but it’s easy to see the principles in action