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

Primary Key are underlined. Crow's foot notation is used.
3 Entities:
Products: (ProductID, Name, ProductType, Cost, Sell_Price) ProductID Primary Key
Orders: (OrderID, Orderplacedon_Date, OrderPlacedOn_Time, Status, DeliveryDate, DeliveryAddress, Payment) OrderID Primary Key
Customers: (CustomerID, Name, EmailAddress, PhoneNo, Address) CustomerID Primary Key

(Date Time ProductID CustomerlD) OrderID OrderPlacedon Status Name Name O Y Product Type Products Contains Orders Place Customers EmailAddress 00000 Otv ( Cost Phone No Sell_Price DeliveryDate Delivery Address Payment Address