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 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
Get step-by-step solutions from verified subject matter experts
