Type the relations produced by mapping the example EER
Type the relations produced by mapping the example EER
Answer
EMPLOYEE(EmpID, Name, MgrID) DEPENDENT(EmpID, DepName, Birthdate) PROJECT(ProjID, Title, Budget) WORKS_ON(EmpID, ProjID, Hours)
MgrID is a recursive FK (unary 1:M), DEPENDENT has a composite PK of owner key + partial identifier (weak entity), and WORKS_ON is the associative relation resolving the M:N with both keys as a composite PK.