All info in JDBCproject.pdf. Requires access to a database. The database is atta

All info in JDBCproject.pdf. Requires access to a database. The database is attached as Company database.
You need to write a well-documented, well-structured and efficient Java program that utilizes JDBC to
generate the following reports. The project will use the COMPANY database as its structure and run on
the classroom environment.
Page one will be an executive summary. For each department in alphabetic order with the manager’s
name, list the project’s (managed by that department) name, total number and hours of all employees
working on the project and the total financial commitment.
Starting with the second you will build a break out report for each project. For each project under the
departments and the location of the project followed by a list of employees working on that
department. With each employee you will print their name, hours worked, financial commitment and
home town. Followed by a total for the projects. This total should match the totals from the first page.
Financial commitment (FC) is calculated as employee’s salary times the percentage of their work week
that is invested in that project. For example, let’s say an employee work 10 hours on a project and is
paid $20,000 then the FC = 20000 * (10/40) = $5,000.