Question: A database for a retailer needs to store data about customers ( identified by c _ id , with name as an attribute ) ,
A database for a retailer needs to store data about customers identified by cid with name as an attribute products identified by pid with price as an attribute and transactions identified by tid with date as an attribute Assume that each transaction is initiated by exactly one customer, a customer may initiate multiple including transactions, and for each transaction, all of the products purchased and their quantities must be recorded eg in the case of transaction units of product X and units of product Y are purchased
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
