Question: A database stores the data of the sales using the primary key RECEIVE _ NUM in the SALE table and the products in the PRODUCT

A database stores the data of the sales using the primary key RECEIVE_NUM in the SALE table and the products in the PRODUCT table with primary key PROD_NUM. To create the relation that represents what products were sold in a SALE a M:N relationship is necessary. What should be used to represent this in a relational model?
composite attribute with RECEIVE_NUM + PROD_NUM
composite entity with RECEIVE_NUM + PROD_NUM
a product table SALE x PRODUCT
a join table S$LE + PRODUCT
 A database stores the data of the sales using the primary

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!