Hi can you help me with this? Draw an ER Model using Visio for the...
60.1K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
