Below is the result of the transformation of the answer to
the big ER model into a set of relations:

*******

Person (_SSN_, Began, Left, Sex, Phone, State, City, Num, Street)

Prof (_SSN_, Rank, Salary; SSN -> Person.SSN)

Student (_SSN_, Grad?; SSN -> Person.SSN)

Ugrad (_SSN_, Major; SSN -> Student.SSN; Major -> Major.MajorID)

Grad (_SSN_, Phd/MS, Affil; SSN -> Student.SSN; Affil ->
      Department.Name)

Advises (_Prof_SSN_, _Grad_SSN_; Prof_SSN -> Prof.SSN; Grad_SSN ->
      Grad.SSN)

Department (_Name_, Address, Chair; Chair -> Prof.SSN)

Affiliated (_Prof_, _Department_, Percent; Prof -> Prof.SSN;
      Department -> Department.Name)

Course (_ID_*, Name, Credits, Num, Dept; Dept -> Deparment.Name)
      *Note surrogte key!

Prereq (_RequiredFor_, _RequiredBy_; RequiredFor -> Course.ID;
      RequiredBy -> Course.ID)

Class (_ClassID_, Sem, Sec, CourseID; CourseID -> Course.ID)

Teaches (_Prof_, _ClassID_; Prof -> Prof.SSN; ClassID ->
      Class.ClassID)

Takes (_Student_, _ClassID_, Grade; Student -> Student.SSN; ClassID ->
      Class.ClassID)

TAs (_Grad_, _ClassID_; Grad -> Grad.SSN; ClassID -> Class.ClassID)

Major (_MajorID_, Name, Dept, BA/S, Credits; Dept -> Department.Name)

Requires (_CourseID_, _MajorID_; CourseID -> Course.ID;
      MajorID -> Major.MajorID)

*****