Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. hi can you help me with this? draw an er model usi

Hi can you help me with this? Draw an ER Model using Visio for the...

60.1K

Verified Solution

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!
Become a Member

Other questions asked by students