Drop table cars;
Drop table types;
Drop table makes;

Create table types
    (type varchar2(10) Constraint types_type_PK Primary Key);

Create table Makes
    (Make varchar2(15) Constraint makes_make_PK Primary Key);

Create table cars
     (Make varchar2(15) Constraint cars_make_FK References Makes(make),
      Model varchar2(25) Constraint cars_model_PK Primary Key,
      LowBase number(8,2),
      HighBase number(8,2),
      LowInvoice number(8,2),
      HighInvoice number(8,2),
      Type varchar2(10) Constraint cars_type_FK References Types(type),
      EnteredBy varchar2(14));

Insert into types values('Sedan');
Insert into types values('Compact');
Insert into types values('Sport');
Insert into types values('Van');
Insert into types values('MiniVan');
Insert into types values('Truck');
Insert into types values('SUV');
Insert into types values('Wagon');

Insert Into makes values ('Acura');
Insert Into makes values ('Aston Martin');
Insert Into makes values ('Audi');
Insert Into makes values ('Bentley');
Insert Into makes values ('BMW');
Insert Into makes values ('Buick');
Insert Into makes values ('Cadillac');
Insert Into makes values ('Chevrolet');
Insert Into makes values ('Chrysler');
Insert Into makes values ('Daewoo');
Insert Into makes values ('Dodge');
Insert Into makes values ('Ferrari');
Insert Into makes values ('Ford');
Insert Into makes values ('GMC');
Insert Into makes values ('Honda');
Insert Into makes values ('Hummer');
Insert Into makes values ('Hyundai');
Insert Into makes values ('Infiniti');
Insert Into makes values ('Isuzu');
Insert Into makes values ('Jaguar');
Insert Into makes values ('Jeep');
Insert Into makes values ('Kia');
Insert Into makes values ('Lamborghini');
Insert Into makes values ('Land Rover');
Insert Into makes values ('Lexus');
Insert Into makes values ('Lincoln');
Insert Into makes values ('Lotus');
Insert Into makes values ('Maserati');
Insert Into makes values ('Mazda');
Insert Into makes values ('Mercedes-Benz');
Insert Into makes values ('Mercury');
Insert Into makes values ('MINI');
Insert Into makes values ('Mitsubishi');
Insert Into makes values ('Nissan');
Insert Into makes values ('Oldsmobile');
Insert Into makes values ('Pontiac');
Insert Into makes values ('Porsche');
Insert Into makes values ('Rolls-Royce');
Insert Into makes values ('Saab');
Insert Into makes values ('Saturn');
Insert Into makes values ('Subaru');
Insert Into makes values ('Suzuki');
Insert Into makes values ('Toyota');
Insert Into makes values ('Volkswagen');
Insert Into makes values ('Volvo');
commit;