PROBLEM:

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$\text{'}$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:

The entities you wish to model

The required$/$important attributes for each entity $($refer to these instructions for guidance on what is required$/$important$).$ 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 MAX$/$MIN cardinalities on each side of the relationship$)$

As you know, One$-$to$-$Many $(1$:N$)$ and Many$-$to$-$Many $($N:M$)$ relationships can be represented by drawing a line between entities with the appropriate crows feet to indicate the "many" side$($s$)$ of a relationship. $"1$:N$"$ and $"$N:M$"$ relationships are also represented using Primary and Foreign Keys, i$.$e$.$ listing a Primary Key from one table and including it as a Foreign$-$Key attribute in a table that you wish to connect to$.$Choose a One$-$to$-$Many 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 $"1$:N$"$ relationship you are doing this for. Do NOT attempt this for any Many$-$to$-$Many relationships you may have in your diagram.