1. Develop a Java GUI application using JavaFx library that will connect to an Oracle database table that has the following specifications:

The database table: Employee 

a.      

Make an Oracle database table named Employee using Oracle SQL Developer. The table Employee should have the following fields: 

·        EmpId (that represents the employee's id, use appropriate data type, primary key).

·        EmpName (that represents the employee's name, use appropriate data type).

·        EmpGrSal (that represents the employee's gross monthly salary, use appropriate data type).

b.     Insert 10 rows of data into table Employee. Use your own customized data (Include your name as the first employee name). The data should be realistic in nature.

Provide a screen shot that displays the contents of the Oracle database table named Employee.                                                                                  [10 marks]

            In the JavaFx GUI application: 

·        Make a well-organized user interface with the help of an appropriate pane manager that has:

a.      A label that reads: Employee's Id no.

b.     A text field: this field will let the user to put an employee id that will be queried.

c.      A label: Employee's Name.

d.     A text field: this field will display the name of the employee retrieved from the database table Employee that relates to the Employee Id entered. No one should be able to modify the contents of this field.

e.      A label: Employee's Gross Salary.

f.       A text field: this field will display the employee's gross salary retrieved from the database table Employee that relates to the Employee Id entered. No one should be able to modify the contents of this field.

g.     A label: Employee's Net Salary.

h.     A text field: this field will display the calculated net salary of the employee as per Employee Id entered. No one should be able to modify the contents of this field.

     The net salary should be calculated using the following formula: 

      Net Salary = Gross Salary - (Gross Salary * .3)

      e.g., If the gross salary is $100, the net salary should be

                 100 - (100 *.3) = 70

i.       A button: Display a Record. If you put a valid Employee Id and click this button, it will connect to the database table Employee and display the entire record (Name, Gross Salary) that corresponds to the Employee Id entered in the respective text fields along with the calculated net salary in the appropriate text field.

Please do not forget to handle exception for invalid Employee Id with an appropriate message.

j.       A button: Reset. If you click this button, it will clear the contents of all the text fields.

k.     A button: Delete a Record. If you enter a valid Employee Id and click this button, it will delete the entire record that relates to the Employee Id entered. Take care of an invalid Employee Id.

l.       A button Quit. If you click this button, it will disconnect the database and leave the application with an appropriate message.