Design an ER diagram for a mini store that represents the following requirements. We have items, each item has a unique ItemID, price, type,
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 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
Step: 1
To design an ER diagram for the mini store we need to identify the entities and relationships based on the given requirements Entities 1 Item Attribut...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started