I have Entity A which has a PK(Order #) and candidate key(Order Sequence #), a unique key which i can use to join some Entities.
I have Entity B which has relationship with Entity A as 1 to Many.
if I define Order # as PK in Entity A then i can make the following ER
Entity A(Order #) ---->> Entity B(Order #)
Say now I want to join the Entity A(Order Sequence #) to Entity C. How can do the following join???
Entity A(Order Sequence #) ---->> Entity C(Order Sequence #)
Since already Entity A(Order #) is PK, the Order # column is being added by default by the tool into Entity C as FK…
Let me know if you have any questions…