A car-rental company maintains a vehicle database for all vehicles in its current fleet. For all vehicles,

Question:

A car-rental company maintains a vehicle database for all vehicles in its current fleet. For all vehicles, it includes the vehicle identification number, license number, manufacturer, model, date of purchase, and color. Special data are included for certain types of vehicles:

• Trucks: cargo capacity

• Sports cars: horsepower, renter age requirement

• Vans: number of passengers

• Off-road vehicles: ground clearance, drivetrain (four- or two-wheel drive) Construct an SQL: 1999 schema definition for this database.Use inheritance where appropriate.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: