Entity Relationships - Can a weak entity take part in a 'one to many' relationship as the 'one'
- by jonos
Hi,
With the following entity relationship structure I'm struggling to figure out if the relationship between the LOAN and ITEM is valid?
The weak entity of Loan uses a partial key of 'loan_dateLeant' and the primary keys from CUSTOMER and ITEM to form its primary key.
However LOAN has a 'one to many' relationship with ITEM as a loan can consist of more than one item.
But surely this means that if more than one item is loaned, then the loan record will have two item_id values for part of its primary key?