Question
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
Get Instant Access to Expert-Tailored Solutions
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