check assigned files for instructions plz.

you will be adding on to existing code that i will provide you.

HW4.doc is the instructions

the RealEstateData is what you modify

INSTRUCTIONS
1. You will write a SQL script file, properties.sql, that builds and populates the properties database. It has at least the following tables. The base data is the same from the previous homeworks. So, the fields in the tables will be the attributes of the classes. This is an exercise in simply building and populating tables. It is not a database design problem. We are not going to use keys, etc. The tables will look like the files.
Owners
CommercialProperties
ResidentialProperties
This script file has nothing to do with Java. It is a separate file.
2. All file manipulation from homework 3 will now be done to the properties database. You will access the appropriate table to find information, update information, and add owners, commercial property, and residential property. You will use Prepared statements. All database methods will be in class DatabaseMethods.
3. The menus will now be
File
Read Database (This reads the tables into the arraylists.)

Add
Add Owner (Add to the list and to the database.)
Add Residential Property (Add to the list and to the database.)
Add Commercial Property (Add to the list and to the database.)

Calculate
Display Taxes

Exit
Write Database (This will write the properties database tables and data to the prompt so I can check to see all data is there.)
Write Owner List (This will write the owners list to the prompt. It will include properties since they are embedded in owner.)
About (This is the version number and your name in a JOptionPane popup box.)
Exit Program

You cannot manipulate only arraylists and then at the end write everything to the database at once.
4. You will turn in all the previous files (with the new GUI functions properties.sql, and DatabaseMethods.java

Click Order now to have a similar paper completed for you by our team of Experts.