Professors have an SSN, a name, an age, a rank and a research speciality. Each project is managed by one professor. Each project is worked on by one or more professors. Professors may work on or manage multiple projects 7. Grad students may work on several projects, and thus may have several supervisors.
Departments have a dept name, dept number, and a main office.
Departments have a chairman who is also a professor. Professors work on one or more departmentts and for each department that they work in, a time percentage is associated with their job. Grad students have one major dept in which they are enrolled for their degree. Exercise 2.5 Notown Records. Each musician has an SSN, a name and address and a phone.