An ER model contains:
CUSTOMER 1:N ORDER
and
ORDER M:N PRODUCT
Quantity is an attribute of the ORDER-PRODUCT relationship.
Which mapping is most appropriate?

Question

An ER model contains: 
 CUSTOMER 1:N ORDER 
 and 
 ORDER M:N PRODUCT 
 Quantity is an attribute of the ORDER-PRODUCT relationship. 
 Which mapping is most appropriate?

Answer

CustomerID, ProductID and Quantity all stored in CUSTOMER

Answer

CUSTOMERID in ORDER; separate ORDER_PRODUCT relation containing OrderID, ProductID and Quantity

Answer

ORDERID in CUSTOMER; Quantity in PRODUCT

Answer

CUSTOMERID in CUSTOMER; PRODUCTID in ORDER

Crowdly

An ER model contains: CUSTOMER 1:N ORDER and ORDER M:N PRODUCT Quantity ...

Want instant access to all verified answers on moovit.vit.ac.in?