Purpose: Build an application to calculate an Employees Gross Pay.

Problem: Build an application that would allow a person to calculate an Employees Gross Pay. The person will enter the employees name, regular hours worked, overtime hours worked and hourly pay rate.The program then calculates and displays the employees name and Gross Pay (see both inputs and outputs listed in the tables below).

Assumptions: Gross Pay = (Regular hours* pay rate) + (Over Time hours * pay rate *1.5) Regular hours are less than or equal to 40

Languages: Java, JDBC, MySQL Steps:

1) Create Employee Table in MySQL

2) Insert Data into Employee table (See Table #1 for Input data)

3) Read Data from Employee table and process in Java

4) Create in java a report (either on screen or in a file ie. Report.txt)

Data Requirements Fields Data-Type Input Employee Info First Name: Last Name: Hours Worked Pay Rate Strin String Double Currency or Double Processes Process Data to calculate Gross Pay Output (See Table #3 for output) Advanced Insert data using java code