Question: A car rental company maintains a vehicle database for all vehicl

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.

View Solution:

Sale on SolutionInn
  • CreatedJanuary 28, 2011
  • Files Included
Post your question