FIT100
Sample Database
Define a university DB schema
•ER
Diagram
•Specifying
a 1-to-many relationship
Faculty
Fac_ID
FirstN
LastN
Dept
Hired
Key:Fac_ID
Student
S_ID
FirstN
LastN
MajorID
Advisor
Key:S_ID
¥
1
Faculty
Student