Question: Problem 3 (Mini-Store Database) [25 Points] Design an ER diagram for a mini store that represents the following requirements. We have items, each item has

 Problem 3 (Mini-Store Database) [25 Points] Design an ER diagram for

Problem 3 (Mini-Store Database) [25 Points] Design an ER diagram for a mini store that represents the following requirements. We have items, each item has a unique ItemID, price, type, and name. We have customers, each customer has unique CustID, name, and address. Each customer can make many transactions, in each transaction a customer may buy one or more items and for each item there is a quantity, e.g., customer 1 makes a transaction buying 3 milk bottles, and 2 canned meat, and 1 chocolate. We also need to capture the transaction date and the total price. Customers may return items that they have previously bought, e.g., customer 1 may return 2 milk bottles from the 3 ones he previously bought. In this return transaction, we need to keep track of which item has been returned, the quantity, the return time, and the original buying transaction. Note: Try to have good design that does not have redundant (un-needed) relationships

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!