Object-Oriented Programming in Java MISM/MSIT 95-712

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

Use Mockaroo to create a text file with 100 rows similar what you see above. Import this into the Staff file.

Write a JavaFX-based JDBC application that provides the following
functionality:
1. Provide an option to enter data into the staff table.
2. Provide an option to display all the records from the staff table.
3. Give menu options to print the following information from the staff table:

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.

2019-11-15

Java

physics

LINUX

C++

Python

Processing

sas

ios

maths

maple

C语言

Internet and World Wide Web

Principles of Programming Languages

sql

scheme

prolog

JavaScript

Haskell

essay

Finance

Accounting

Rust

Economics

算法分析（Algorithm analysis）

MATLAB

Ethics

Chemistry

LaTeX

OCaml

SPSS

Project

ASP

Stata

FORTRAN

Information system

SDLC

Basic

Digital Media

Biological

Android

ruby

HTML/CSS

Scala

PHP语言

C#

R语言