Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Furniture store would like to track their customers and the products they buy from them on a daily basis. The store would like to

A Furniture store would like to track their customers and the products they buy from them on a daily basis. The store would like to know the customers dob, name, address, email and telephone number. They are aware that persons may have many email address and would like to store as many emails as possible for the customer. They also prohibit persons in different age groups from buying certain fruits, so they would like to know the age of each person. They would like to search their database for last names and first names to make finding a customer easier. Any customer is allowed to by more than one product at a time and the store would like to store a re-order level for each product. The store would lie to keep track of all invoices it issues. Customers do not have to buy fruits for their information to be stored. They can also be contacted if new products are available a) Draw an ERD diagram for the above scenario.

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

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions

Question

=+What about SRI funds? Why, or why not?

Answered: 1 week ago