What table relationship is illustrated in the following data structure (if the relationship is evaluated from left to right)?
What table relationship is illustrated in the following data structure (if the relationship is evaluated from left to right)?
Evaluating the relationship from left to right, the relationship in the data structure involves multiple 'Product' records being associated with a single 'Supplier' record. Therefore, this relationship is described as Many-to-One (M:1), as several products can be provided by one supplier.
It this should be B ?
correct answer is B
C is correct. This relationship is a "one-to-many" relationship because one supplier can supply many different products, but each product can only be supplied by one supplier.
The questions says "left to right" so many to one
It says evaluated from left to right so wouldn’t that make it many to one?
Many to One
left to right many -> one B