Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me with this ERD ? I'm confused. General Auto Sales utilizes salespeople to sell automobiles to customers. A Salesperson has a Sales

Can someone help me with this ERD ? I'm confused.

General Auto Sales utilizes salespeople to sell automobiles to customers. A Salesperson has a Sales Person Id (unique), Name, and Phone number. Automobiles are identified by a Vehicle Id (VIN). They also have a Make, Model, Year, and Sale Price. Customers are identified by their Phone Number. Customers also have a Name (First and Last), and Address (Street Address, City, State , and Zip). A Sales person may make several sales or they may make none. A Customer may purchase several Autos or they may buy none (they are just looking). An Auto may or may not be sold but it can only be sold once. When the sale of an automobile is made by a Salesperson to a Customer, the Purchase Price (which may be different than the autos sale price), and the Purchase Date is recorded. (Point to consider: automobile is sold to customer by salesperson through a sale; each sold automobile is considered a sale). Resolve Multi-value attributes & make assumptions only if necessary.

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

More Books

Students also viewed these Databases questions

Question

Why is the games industry so much bigger than the music business?

Answered: 1 week ago