Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions