Hi, if my tenary relationship is 1:M:N would i add the primary key of the entity on the 1 side as a foreign key in the table of the associative entity (as opposed to part of it's composite primary key)
If you have a ternary relationship, you need to consider everything as if it was a many-to-many-to-many relationship. So, yes, you would either have all the foreign keys make up the primary key or you need to create a surrogate primary key.
This is wayyyyyy better than my professor taught in class. Thank you so much.
so true
Hi, if my tenary relationship is 1:M:N would i add the primary key of the entity on the 1 side as a foreign key in the table of the associative entity (as opposed to part of it's composite primary key)
If you have a ternary relationship, you need to consider everything as if it was a many-to-many-to-many relationship. So, yes, you would either have all the foreign keys make up the primary key or you need to create a surrogate primary key.
hello sir thank you for the video
what book did you use as a reference
Thankyou so much you're a life saver
Super Clear! Thank you!
great video 👍
gold
thanks :>