Question: Problem 2 (Continuation) d) (10 pts) You are required to represent in an E-R Diagram cars, car dealers, and the cars sold by the dealers.

 Problem 2 (Continuation) d) (10 pts) You are required to represent

Problem 2 (Continuation) d) (10 pts) You are required to represent in an E-R Diagram cars, car dealers, and the cars sold by the dealers. The car dealer has a dealer id (a primary key), dealer name, and dealer phones (can have multiple phones). The car has a car id, serial number, model and price. Your E-R must capture the fact that some cars have models with different options and that t a Mitsubishi Nativa might come in three options: 1) SE : has no CD-player, 2) LS: has a single disc CD-player and a spoiler, or 3) XLS: has a CD changer with 6 CDs, leather seats, spoiler, and sunroof. In addition, it must represent the fact that every car must be sold by some dealer. Draw an E-R to capture this information. hese options ad d a n extra charg e to the car price. For example

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!