Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Design an ER diagram for a mini store that represents the following requirements. We have items, each item has a unique ItemID, price, type,

image text in transcribed

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... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Relational Database Design

Authors: Candace C. Fleming, Barbara Von Halle

1st Edition

0201114348, 978-0201114348

More Books

Students explore these related Databases questions