Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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