please develop a spreadsheet to solve the companys issues

Billing Data On-The-Level Construction Company is a Denver-based construction company that specializes in subcontracting the development of single-family homes. In business since 1998, On-The-Level Construction has maintained a talented pool of certified staff and independent consultants providing the flexibility and combined experience required to meet the needs of its nearly 300 completed projects in the Denver metropolitan area. The field of operation methods that On-The-Level Construction is responsible for includes structural development, heating and cooling, plumbing, and electricity. rate depends on the empers its clients by billing the hours spent on each contract. The hourly billing Figure AYK.5 shows a basic repos position according to the field of operations (as noted previously). week concerning what projects are that On-The-Level Construction foremen would like to see every for the assignment. On-The-Level Coing assigned, the overall assignment hours, and the charges Structure (500), Plumbing (501), Electricaction organizes its internal structure in four operationsoperational departments can and should (502), and Heating and Ventilation (503). Each of these On-The-Level Construction has decided have many subcontractors who specialize in that area. details according to project name, Originally, On-The-Level Construc, hours assigned, and charges per hour for each job description. of the database. However, thatruction decided to let one of its employees handle the construction On-The-Level Construction that employee has not had the time to implement the project completely. The entities and primary has asked you to take over and complete the development of the database. The following business rueys for the database have been identified in Figure AYK.6. business rules have been identified: 1. A job can have many employees assigned but must have at least one. 2. An employee must be assigned to one and only one job number. 3. An employee can be assigned to work on one or more projects. 4. A project can be assigned to only one employee but need not be assigned to any employee. Your job is to complete the following tasks: 1. Develop and describe the entity relationship diagram. 2. Use normalization to ensure the correctness of the tables (relations). 3. Create the database using a personal DBMS package (preferably Microsoft Access). 4. Use the DBMS package to create the basic report in Figure AYK.5. 4. Use the DBMS package to create the basic report in Figure AYK.5