Question
(Crow's foot notation) Assume the following scenario : A car dealership keeps track of its salespersons and cars sold. For each salesperson, it records the
(Crow's foot notation) Assume the following scenario : A car dealership keeps track of its salespersons and cars sold. For each salesperson, it records the SalespersonID, first name and last name. Each salesperson has its own salespersonID. For each car, it records the make, model and the VIN number which is used to identify each car. For each of a and b, an extra information is added to the scenario. Use the scenario above and the respective extra information to draw the corresponding ER diagram for each of a. and b. By using (Crow's foot notation) Your ERD should show the cardinalities of each relationship. a) Each salesperson may sell many cars, but each car must be sold by only one salesperson. b) It is required for each salesperson to sell at least one car and all cars must be sold. It is common for several salesperson to work together to sell a car.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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