~/ learn/ comp-378/ cards/ Transforming EER Diagrams into Relations (the 7 Rules)
1 of 4

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/f60c9a7a-44f6-425b-954d-bd2a4d92737f/flashcard utf-8 LF