Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

Compose the six common types of social business messages.

Answered: 1 week ago

Question

Describe positive and neutral messages.

Answered: 1 week ago