Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Auditing Tool Towards A Generic Approach To Audit Business Processes Of An Information System On The Fly

Authors: Bhawna Mallic, Kopal Gakkhar

1st Edition

3838395115, 978-3838395111

More Books

Students also viewed these Accounting questions

Question

What do you think his objectives are?

Answered: 1 week ago

Question

To solve p + 3q = 5z + tan( y - 3x)

Answered: 1 week ago