Question
Hi can you help me with this? Draw an ER Model using Visio for the following. Make sure you assign appropriate attributes for entities/tables, including
Hi can you help me with this?
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, date an SA made first contact with a customer, total cars sold in a month by an SA
Thank you so much
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started