Question: EXERCISE #2 - Define an ER schema to describe car catalogs along with price for car models and info about car makers - Information of

 EXERCISE #2 - Define an ER schema to describe car catalogs

EXERCISE #2 - Define an ER schema to describe car catalogs along with price for car models and info about car makers - Information of interest . Car makers, with name (identifier), and address Car models, with name (identifier), initial production year, and description, e.g. "Compact") - Model versions, identified via the car maker (e.g. Nissan), the car model (e.g. Sentra), and a specific name (e.g. SR); a model version also has: price, engine, displacement, horsepower, number of doors and top speed. Note: each version is associated with one, and only one, engine - Engines, with a code (identifier), displacement, number of cylinders, horsepower. An engine may not be used in any car model

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!