Computer Science - Java CS Assignment (Netbeans required)

profilecolinzhw
cars_db-12.sql

DROP TABLE CarsTable; CREATE TABLE CarsTable ( CarID INT NOT NULL GENERATED ALWAYS AS IDENTITY, CarMake VARCHAR (10) NOT NULL, CarModel VARCHAR (15) NOT NULL, CarYear VARCHAR (4) NOT NULL, CarMileage DECIMAL (6) NOT NULL ); INSERT INTO Cars (CarMake,CarModel,CarYear,CarMileage) VALUES ('Honda','Civic','1998',135647), ('Honda','Accord','2009',46877), ('Toyota','4Runner','1998',221076), ('Volkswagon','Golf','2009',112087);