Question: Extend the ERD from Problem 3 with the Product entity type and an M - N relationship between Product and Order. Choose an appropriate relationship
Extend the ERD from Problem with the Product entity type and an MN relationship between Product and Order. Choose an appropriate relationship name using your common knowledge of connections between products and orders. Define minimum cardinalities so that an order is optional to a product, and a product is mandatory to an order. For the Product entity type, add attributes ProdNo primary key ProdName, ProdQOH, ProdPrice, and ProdNextShipDate. For the MN relationship, add an attribute for the order quantity. If you are using a data modeling tool that supports data type specification, choose appropriate data types for the attributes based on your common knowledge.Revise the ERD from Problem by transforming the MN relationship into an associative entity type and two identifying, M relationships.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
