Reference no: EM133234858

A university database contains information about professors (identified by social security number, or SSN), departments (identified deptid), and courses (identified by courseid).

Professor has SSN, Name (made of first name and last name), Email

Courses have courseid, name. Courses also have multiple attributes for the section numbers

Departments have deptid, address, name

Professors must work for 1 department

Departments must have a department head (who is a professor)

Departments offer multiple courses

Professors teach multiple courses

Courses can have multiple professors with multiple sections.