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 c_id, with name as an attribute), products (identified by p_id, with price as an attribute) and transactions (identified by t_id, with date as an attribute). Assume that (1) each transaction is initiated by exactly one customer, (2) a customer may initiate multiple (including 0) transactions, and (3) for each transaction, all of the products purchased and their quantities must be recorded (e.g., in the case of transaction 1234,2 units of product X and 3 units of product Y are purchased).

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 Programming Questions!