You will create a data model for a car dealership. It will be used to generate a physical database used to track information about salespersons, customers and vehicles. The following is a list of the business rule requirements:

• Salespersons are identified by an employee id. It is important to keep track of their first name, last name, hire date, wage rate, commission rate, phone and email address.
• Customers are identified by their customer id. It is also important to keep track of customers first and last name, phone, email, address, city, state and zip code.
• A vehicle is identified by its vehicle id. It is important to store the vehicles VIN, make, model and color.
• Each salesperson can show one or more vehicles to customers. Each vehicle can be shown to customers by one or more salespersons.
• Each salesperson can work with zero or more customers. Each customer can work with one and only one salespersons.

Complete the following steps:

Step 1: Create/save a data model in LucidChart (or) MySQL Workbench. You must create all necessary entities, attributes, relationships (foreign keys) and primary keys). When you have completed the data model, you must export the design as an image or take a screenshot of the design. Add the image/screenshot to this Word document.

Step 2: Explain your design including: any additional constraints and any assumptions you made to the business rules above.