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
¥