This program will work with data from an earlier place in the book to get more practice with databases. $($You can create this as a GUI version or a Console version. It is up to you on this.$)$

The $.$sql script to create the employees from chapter $10$ in a database is attached to this assignment link. You can open it up in notepad. $($There is usually a one to one relationship between the database tables and the Data Classes which are shown in chapters $3$ and $8-10$ in this book. Note that the classes with inheritance have records in both the parent class table and subclass table with the same Primary Key ID as the key and a Type to match on$,$ so the records in different tables can be read$/$inserted$/$updated together. $....$Looking at this you have just now learned how it is managed in a database and also have an example to keep on how the data is stored! $.......$For simplicity and because you have a project with a database to work on$,$ we will be ignoring the subclasses. The script is a good one to use parts for our database for this assignment though.$)$

For the program:

$(1)$ Create a derby database and a Java program that connects to it$.$ The java program should have the statements to create the Employee Table $($and only this table, not the others like salariedEmployees$)$ and insert the four employee records into the table.

$(2)$ Create GUI controls to allow the user to give the data and add a new employee into the table, or write the statements in a console program to repeat $3$ times asking the user for the data for a new employee and then add them into the table.

$(3)$ Create a button $($or have the Console program do it at this point$)$ to display the seven employees currently in the database.

$(4)$ Create another button $($or Console code to do it at this point$)$ and Textfields to change an employees department using a Social Security Number and new department name entered by the user.

$(5)$ Create another button and TextField to delete an employee by Social Security number.

$($If you did a Console version, make sure to display the current records in the employee table one last time for the user so they can see the changes from $4.$ and $5.)$