Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

A Clothing 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) Derive an ERD diagram for the above scenario. Ensure that all the defined terms are used in your solution. b) Display the cardinality of each relationship c) State the degree of your relationship d) Ensure that the relationship shows entity participation

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

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions