1. (60 points) Create a table called Staff within a database called EmployeeDB. You can use the embedded Java DB mode or client/server mode to implement this database.

The staff table looks like this:

Lastname	Firstname	Position	Salary	Age
Woman	Wonder	Engineer	51494	42
Python	monty	clerk	70653	22
Kent	Clark	cook	62194	31
doctor	strange	Technician	81245	56
Simpson	Homer	Mechanic	70003	34

a. A list of staff displayed by Position.

b. The staff members earning the least, highest and above average salaries.

c. A list of staff members who earn more than $55000.
d. Any JavaFX chart that is generated using the data from the table (for example “a chart showing average age for each position”). 

2.(40 points) Design and code a JavaFX GUI to translate text that is input in English into a special coded language. You can assume that  the sentence contains no punctuation. The rules for this secret language are as follows:

a. For words that begin with consonants, move the leading consonant to the end of the word and add “ay.” Thus, “ball” becomes “allbay”; “button” becomes “uttonbay”; and so forth.
b. For words that begin with vowels, add “way” to the end of the word. Thus, “all” becomes “allway”; “one” becomes “oneway”; and so forth.
b. For words that begin with vowels, add “way” to the end of the word. Thus, “all” becomes “allway”; “one” becomes “oneway”; and so forth.

Your GUI may look like the UI here: https://www.textfixer.com/tools/remove-line-breaks.php

Submission

Submit as per usual requirements. Demonstrate to the TA’s during your allotted session times.