Question
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
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