A database designer is modeling a University system. Students can be…
GPSC College Teaching (CS/IT) 2025
A database designer is modeling a University system. Students can be Undergraduate or Graduate. All Students have a student_ID and name. Undergraduates have a major and advisor, while Graduates have a research_area and thesis_committee. Students can also be Teaching_Assistants or Research_Assistants, both of which are Employees and have salary and employee_ID. Which of the following E-R features best represents this scenario and offers the most modular design?
- A.
Using multiple binary relationships and composite attributes to link Student, Employee and their specific types.
- B.
Employing a hierarchical generalization/specialization for Student (into Undergraduate/Graduate) and a separate one for Employee (into Teaching_Assistants/Research_Assistants), possibly with Teaching_Assistants/Research_Assistants having multiple inheritance from both Student and Employee to form a lattice.
- C.
Creating a single entity set person with all attributes of Student, Undergraduate, Graduate, Employee, Teaching_Assistants, Research_Assistants and using nulls for non-applicable attributes.
- D.
Defining Student and Employee as weak entity sets, with their specific types as strong entity sets.
Attempted by 81 students.
Sign up free to check your answer
Sign up freeLoading lesson…

