SharpCoder Only (New)

Overview You will be creating a user interface in Swing to a simple database.

Description A car dealership needs a simple database to track customers, create a quote, and

manage inventory. The main screen should look something like the screen below.

You will design the other screens.

Manage Inventory This screen should allow you to add, remove, and update vehicles in the inventory. A vehicle record must include • VIN number • Make • Model • Year • Color • Base Price

- 1 -

Create Quote This screen should allow you to create a quote on a vehicle. The user should be able to • Select a customer • Select a vehicle from inventory • Enter an interest rate • Enter the number of years for the loan After entering the values, the system should show a complete amortization schedule

(in a scrollable window of some sort). Assume simple annual interest, 12 monthly

payments, and a sales tax rate of 4.75%. Quotes should be saved in the database.

The complete amortization schedule should not be saved - only the customer,

vehicle, interest rate, and years for the loan.

Manage Customers On this screen you should be able to create, edit, and remove customers from the database. Customer records should include • Last and first name • Day that the came into the dealership the first time (the day the record was created) • Phone number • Notes on what they were interested in

Database You can use either the Derby database or another database of your choice. Part

of your pro-gram should populate the database with some data for testing.

Academic Honesty You are expected to use the internet when looking for information. You are not

allowed to do any of the following: Copying files or code from another project or directly from the Internet. You may of course

use the internet to research solutions. Posting to boards such as Stack Overflow Violation of the above will be considered as violating academic honesty rules.

What to Turn In All java files for the project must be turned in. The program MUST COMPILE to be

graded. Applications that do not compile will be given a zero (0).

- 2 -