Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Note: Crow’s Foot Database Notation is required Question Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. areEach of these three entity types has a unique attribute identifier. The attributes that it stores are as follows: a. Salesperson Number(unique), SalespersoMaken Name, Salesperson Telephone, Hire Date b. Customer Number(unique), Customer Name, Customer Address, Value of Last Purchase c.Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price
Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys.
Note: Crow’s Foot
Question
Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. areEach of these three entity types has a unique attribute identifier. The attributes that it stores are as follows:
a. Salesperson Number(unique), SalespersoMaken Name, Salesperson Telephone, Hire Date
b. Customer Number(unique), Customer Name, Customer Address, Value of Last Purchase
c.Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price
Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Crow’s Foot Database Notation is required.Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Note: Crow’s Foot Database Notation is required Question Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. Each of these three entity types has a unique attribute identifier. The attributes that it stores are as follows: a. requireSalesperson Number(unique), Salesperson Name, Salesperson Telephone, Hire Date b. Customer Number(unique), Customer Name, Customer Address, Value of Last Purchase c.Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Crow’s Foot Database Notation is require
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
