Question: Draw an EER diagram for the following problem using this texts EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by
Draw an EER diagram for the following problem using this text’s EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:
In a typical university, people occupy one or more roles.
There are students, either undergraduates or postgraduates, each of whom has an ID number, enrolment, and expected graduate date. Undergraduates have a major, while postgraduates have a thesis title and supervisor.
Faculty comprises lecturers and teaching assistants, both of whom have an employee ID. Lecturers have a salary and teaching group, whereas teaching assistants are paid by the hour. All university members have a name, address, and date of birth. Sometimes faculty members may also be studying for a PhD.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
