What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID,Description)
SUPPLIER (SupplierID,ContactName,PhoneNumber)
PRODUCT_SUPPLIER (ProductID,SupplierID,Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship

Question

Quizplus · Accepted Answer

The schema illustrates an association relationship where the PRODUCT_SUPPLIER table acts as a bridge table associating products with suppliers, ensuring that each ProductID and SupplierID in PRODUCT_SUPPLIER exists in the PRODUCT and SUPPLIER tables respectively.

What Relationship Pattern Is Illustrated in the Following Schema