Problem
Draw an ER Model using Visio for the following. Make sure you assign appropriate attributes for entities/tables, including the Primary Key (PK) and Foreign Key (FK): A local car dealership in Lynn, MA wants to keep a track of their sales. A sales agent (SA) at the dealership can sell many cars, but a car can be sold by only one SA. An SA can sell to many customers; however, once a customer is assigned to an SA, they cannot switch to another SA unless an SA's supervisor is notified. A supervisor at the dealership manages several SA's, while an SA has only one supervisor. The dealership wants to track all pertinent information including sale price of every car, date of sale, make and model of the car sold, car VIN, date an SA made first contact with a customer, total cars sold in a month by an SA. (Note: each table/entity in your ER model must have at least two attributes including the ones specified in the problem.