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 RECEIVENUM in the SALE table and the products in the PRODUCT table with primary key PRODNUM. 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 RECEIVENUM PRODNUM
composite entity with RECEIVENUM PRODNUM
a product table SALE x PRODUCT
a join table S$LE PRODUCT
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
