(Solved) : Database Retailer Needs Store Information Customers Identified C Id Name Attribute Product Q32603724 . . . .

A database for a retailer needs to store information aboutcustomers (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 onecustomer,

(2) a customer may initiate multiple (including 0) transactions,and

(3) for each transaction, all of the products purchased andtheir quantities must be recorded (e.g., in the case of transaction1234, 2 units of product ’X’ and 3 units of product ’Y’ arepurchased).

(a) (15 points) Draw an E/R diagram that captures all of theabove information.

(b) (15 points)