Mapping Unary M:N Relationships,”Mapping this relationship requires adding an intersection relation:MECHANIC(MechID, Salary)SUPERVISES(SupervisorID, SuperviseeID)In this case

Database
Average Rating
0 out of 5 stars. 0 votes.

Mapping Unary M:N Relationships,”Mapping this relationship requires adding an intersection relation:MECHANIC(MechID, Salary)SUPERVISES(SupervisorID, SuperviseeID)In this case

both SupervisorID and SuperviseeID are foreign keys that reference the primary key MechID. Together they create the composite primary key of SUPERVISES”