I have the following ER Model
I am trying to convert this to a relational database schema but I am not sure about several things:
PORT_VISITandPORTare weak entities. How do I figure on which strong entities they are dependent upon ? Usually, this would be easy in a binary relationship but the ternary relationshipSHIP_AT_PORTis confusing me.- SHIP and PORT are related by N to 1 relationship HOME_PORT. With the relational schema, the usual idea is to put in the entity close to the N (
SHIPin this case) as a foreign key the primary key of the 1 entity(PORT). ButPORTin this case is a weak entity, so do I use the partial key ?
If anyone can answer these questions and/or show me relational schema, I would be highly appreciative. Thanks !
Aucun commentaire:
Enregistrer un commentaire