Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

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

Step: 3

blur-text-image

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

Databases A Beginners Guide

Authors: Andy Oppel

1st Edition

007160846X, 978-0071608466

More Books

Students also viewed these Databases questions