Question

Create an Entity relationship diagram and write a databased design outline for the following:

1. You want to keep track of sales team’s current sales activity. For each salesperson, you want to store unique employee ID, first name, last name, home address information, phone number, and email address. Your customers are typically retails stores and, for each customer, you want to store customer ID, name of business, phone number, address information and salesperson’s information. Also, for each customer, you want to store the main contact person’s first name, last name, and phone extension number. Single salesperson can handle multiple customers, but single customer cannot have multiple salesperson from our company at a time. Customer make orders. For each order, you want to store order ID, date order placed, total spending for the order, and which customer placed the order.

Answer 1