Instructions:
1. Read the Database Assessment Case Study Background (Database Case Study Background.docx)
2. Identify the entities and attributes of the database module using the following information:
a. Santos Tour Down Under must maintain information about its sales reps, customers, product inventory, order.
b. For the sales rep, the sales rep number, last name, first name, street address, city, state, zip, country total commission , and commission rate for each sales rep must be recorded
c. Customer information must also be maintained including the customer number, name, street address, city, state, zip, country, current balance, and credit limit for each customer, as well as the number of the sale rep who represents the customer.
d. The product id, product name, product colour, quantity available, its manufacturer id and unit price are also maintained.
e. For each order, the order number, date order was placed, and the customer number that placed the order must also be stored.
3. Identify the relationships among entities using the following information:
a. A customer can only have one sales representative but a sales representative can have one or more customers.
b. A customer can have zero or more orders and each order has one customer.
c. An order can have several products and a product can have several orders.
d. Given the order number and the product ID, the quantity of products ordered and the quoted price is stored (Hint: these attributes should be added once the many-t-many relationship between order and product is resolved, the new entity should be called orderline).
4. Create the database model using E-R Diagram. You can use draw.io or any of the E-R diagram drawing tools you prefer.