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.


$1.99
Sales0
Views925
Comments0
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000