1) Take the suppliedcars_db.sql and create your Cars database (you will have to create the Cars database first, then execute the .sql file from within Netbeans).
2) Implement a program that has the same general user interface as the SimpleSchoolData presented in class.
3) Implement two classes, CarsDisplay which displays the above application, and implement a class named CarQueries that contains the prepared statements to execute the queries.
(Java)
This is thecars_db.sql
DROP TABLE Cars;
CREATE TABLE Cars
(
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),
('Nissan','Pickup','1997',235444);