Write a GUI application in Java using JavaFX that allows user to:

$1$

$)$

$$Add car information to a database. You must create all eight fields shown in the next page screenshot and follow the same design. The car type combo box should have

$3$

$$values SUV

$/$

Sedan

$/$

Van

$.$

$$By adding a new car the new entry should appear in the table view.

$2$

$)$

$$Delete selected cars from the database. The car should be selected by clicking on the table view row.

$3$

$)$

$$Filter table of cars by selecting make, model, type, year range, location, mileage range, and price range. If all conditions are provided regarding make, type, model, year, location, mileage, and price, all of them should be applied to the filter function. If they are provided partially, only the ones that are not empty should be considered to filter the data. Please make sure in your video demo you show insert data, delete data, and all filtering combinations. If your UI does not work properly, at least demo the data insert, delete, and access dataThe application should retrieve the car information from an Oracle table named Car. Here is the definition of the table:

CREATE TABLE Car

$($

$$ carID integer NOT NULL,

$$ make varchar

$($

$20$

$)$

$$NOT NULL,

$$ model varchar

$($

$100$

$)$

$$NOT NULL,

$$ type varchar

$($

$100$

$)$

$$NOT NULL,

$$ b

$\_$

year integer NOT NULL,

$$ location varchar

$($

$100$

$)$

$$NOT NULL,

$$ mileage integer NOT NULL,

$$ price integer NOT NULL,

$$ PRIMARY KEY

$($

carID

$)$

$)$

;

Car Data

Mcdel

FiltersCar Data

Mcdel

Filters