entity relationship - ER Diagram Design Method -


i have entity: employee. @ top of er diagram (rectangle box)

i have entity: crew. second object on er diagram (rectangle box). under above rectangle.

i have composite entity, containing foreign keys made of primary key employee_id , crew_id

because composite entity contains foreign keys employee , crew table, mean have draw line in er diagram composite entity 2 rectangles, or 1 above it?

enter image description here

one many relation of employee , crew above


Comments