FIT 100
© Copyright University of
Washington 1999-2000
Designing A Database Schema
vSuppose 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?
oStudents: first
name, last name, home address, transcript …
oFaculty: first name,
last name, SS#, home address, rank …
oCourses: class name,
number, students attending, grades …
vDeciding 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
Avoid redundancy!