Question

You are asked to design a data model for The Wagging Tail, an online store that sells products for dogs, e.g. dog collars, dog food, dog toys, dog treats, etc. You want to keep track of three entities: (1) the products that the store sells, (2) customers who purchase the products, and (3) 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's/table's 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: 1. The entities you wish to model 2. The required/important attributes for each entity (refer to these instructions for guidance on what is required/important) 3. The relationships between the entities 4. The correct MAX and MIN Cardinalities for each relationship (remember for each relationship, or line, there are MAX/MIN cardinalities on each side of the relationship)

Answer 1

The solution to this question can be defined as follows:

Step-by-step explanation:

In this question the Primary Key as defined in the underlines that use the Crow's foot notation which is defined in the 3 entities that can be defined in the attachment file: