What two attributes must be contained in the composite entity between STORE and
PRODUCT? Use proper terminology in your answer.
The composite entity must at least include the primary keys of the entities it references. The
combination of these attributes may be designated to be the composite entity's (composite) primary
key. Each of the (composite) primary key's attributes is a foreign key that references the entities for
which the composite entity serves as a bridge.
As you discuss the model in Figure Q4.17sol, note that an order is represented by two entities, ORDER
and ORDER_LINE. Note also that the STORE’s 1:M relationship with ORDER and the ORDER’s
1:M relationship with ORDER_LINE reflect the conceptual M:N relationship between STORE and
PRODUCT. The original business rules probably read:
• A store can order many products
• A product can be ordered by many stores.