Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROBLEM: You are asked to design a data model for The Wagging Tail, an online store that sells products for dogs, e . g .
PROBLEM:
You are asked to design a data model for The Wagging Tail, an online store that sells products for dogs, eg dog collars, dog food, dog toys, dog treats, etc. You want to keep track of three entities: the products that the store sells, customers who purchase the products, and the orders that are made on the website. Draw an ERD diagram and use the following information to help guide your drawing:
The database should keep track of all products that the store offers for sale
The database should keep track of all customers who have registered with the store website
The database should keep track of all orders placed on the website
At most only a single customer can be related to any single order
A customer can place multiple orders with the website
Each entity must have a unique identifier within its table. This is the Entity'stables Primary Key.
An order must consist of at least one product, and may consist of multiple products
You wish to keep track of the cost of the product to the store, and the price that the store sells a product to the customer
You wish to be able to contact customers via phone and email
You wish to be able to determine when is the busiest time of year for your website according to number of orders placed
Your drawing should include the following:
The entities you wish to model
The requiredimportant attributes for each entity refer to these instructions for guidance on what is requiredimportant Also include an appropriate Primary Key as an attribute for each entity
The relationships between the entities
The correct MAX and MIN Cardinalities for each relationship remember for each relationship, or line, there are MAXMIN cardinalities on each side of the relationship
As you know, OnetoMany :N and ManytoMany N:M relationships can be represented by drawing a line between entities with the appropriate crows feet to indicate the "many" sides of a relationship. :N and N:M relationships are also represented using Primary and Foreign Keys, ie listing a Primary Key from one table and including it as a ForeignKey attribute in a table that you wish to connect toChoose a OnetoMany relationship in your diagram a line that connects two entities and represent that relationship, using a Primary and Foreign Key to do so Clearly label the :N relationship you are doing this for. Do NOT attempt this for any ManytoMany relationships you may have in your diagram.
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