Chapter 8, Problem 3PE

Explanation of Solution

SQL schema definition

• “Color” and “DriveTrainType” are pre-defined data types and use the table inheritance.
• “Vehicle” relation is considered.

  create type Vehicle(vehicle_id integer, license_number char(30), manufacturer char(30), model char(30), purchase_date char(30), color Color)

  create table vehicle of type Vehicle

• “Truck” relation as child of “vehicle” relation is considered.

  create table truck (cargo_capacity integer) under vehicle

• “sportsCar” relation as child of “vehicle” relation is considered...