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 emptoye 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 Constassigned, the overall assignment hours, and the charges Structure (500), Plumbing (501), Eonstruction 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 decidild have many subcontractors who specialize in that area. details according to project namecided to implement a relational database model to track project 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 primas 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. Billing Data On-The-Level Construction Company is a Deowythated coritrection company that specialles in subcentrecting the dewelop enent of single-taniy bemes; in busitess shce 1993, On-the-Levei. Construction has maintained a laleoted posi of cenfifed sutf and indepenident comeitants proving the fexbility and corabined expenitince required to meet the needs of its neacly 300 complated pich: ects in the Denver metropolitan aiea. The feld of optrosios methods that On The tevel Canstriction. is responsible for includes structurat developtnent, heseing and cooling. plumbing, and electicty. The company chasges its cients by biling the hours speot en each contrat. The eocely biling Tate depends on the errployee's posilion accocding to the fild of operoticns (as noted priviausly? Figuie Avk 5 shews a basic report that On-The Level Conotruction forernen would lake to see ever week conceming what propects are being assigned, the overill asipument hours, and the chargas for the angiginent OnhiThe-Leed Construction organites its interea structuce in four pperationsStructure (500), Plumbing fon. Eectricol (502t and Heating and Veotation (503) Each of these operational depurimens can and should hwe many subcontractors whe specialize in that area. On-The-1vel Construction has decided to imyloosent a relstion database model ts truck project details accoriting to project name, hours astigned, and charges por hou for oach jab deseription. Originally. Or-The-tevel Construction decided to let one of is enpleyest handie the construction of the dalabase. However, that employee has not had the time to inpinmant ne project completely. On-The Level Constructian has asked you to take over aed comolete the development of the database. The entities and primary heys for the database hive beeo idencifed in Fiqure AYk.5. The following business rules have been identified. 1. A.job con have many employees assigned but must herve at least one. 2. An emigloyee munt be assigned to one and baly one job numbic. 3. Ait eriblojee can be assigned to work on ose or more projects. 4. A proioct can be assigned to only one omployee but need not oe assigned to any moloyse. Yout fob is to complete the lollowing tasks: 1. Develop and describe the entity relationship diagram 2. Use normalization to ensure the correciness of the tables feelations). 3. Create the database using a personal DeMs package fpreferably Microset Accemy. 4. Use the DBMS patkage to create the baskcrepert in figure Ank.5. FIGURE AYK.S On-The-LevelConstructoso Detail Regont Billing Data On-The-Level Construction Company is a Dether-bered coestriction compary that specializes in subcontracting the development of single-ferly tones, in bunioss since 1998, On-The-Level Construction has maintained a talented poot of certiled aze in and inserpendent consitants pronding ects in the Denver metropolitan ancence required to mest the neest of ta maly 300 conpleled prof. is responsible for includes structurald Thevelioid of eperitos nethods that On-The-tevel Construction The compony charges its clients by billing the heating and cooling alumbing, and electricity. rate depends on the employee's pesition accoring hoss spent on each contract. The houly billing Figure AYK. 5 shows a basic report that on. The teing to the feid of ocericoes fos noced previcushl. week concerning what projects are being the-tewil Coratruction forenes would lise to see every for the assignment. On-The-Level Constg assigned, the oviral anslgaroent hours, and the changes Siructure (500). Plambing (507), Electrical (502) onganiaks as intemal structure in four eperationsoperational departments can and should (502) and Heding and Ventiation (503). fach of these On-The-Level Construction has decided is ingie many subcectracss ato specialize in that area. details according to project name, hours to implement a relatonve denabuse modet to track praject Originally, On-The-Level Construction deectsigned, and charres per hour for each job tescription. of the database. However that eofion decided to let ene of is employess tandle the construction. On-The-Level Construction has ashejoyce has not had the tine so irplenent the project completely. The entities and prim has asked you to take over and conglete the development of the database. The following business keys for the databese tave been idert ted in Fifure Ank. 6 . 1. A job can have many employees arsigned but most have at kast ane. 2. An employee must be assigned to one and anly ore jpb numbe:. 3. An employee can be assigned to work on one or more proincts. 4. A project can be assigned to only one employee but need not be andigned to any employee. Your job is to complete the following lask: 1. Develop and describe the entity relationstip dispram. 2. Use normalization to ansure the correctness of the lables fretarione: 3. Create the databasy ueing a personal DEMS package forelerably Microsoft Accesst. 4. Use the DBMS pockage th create the basic report in Figure Ah 5 . 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 emptoye 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 Constassigned, the overall assignment hours, and the charges Structure (500), Plumbing (501), Eonstruction 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 decidild have many subcontractors who specialize in that area. details according to project namecided to implement a relational database model to track project 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 primas 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. Billing Data On-The-Level Construction Company is a Deowythated coritrection company that specialles in subcentrecting the dewelop enent of single-taniy bemes; in busitess shce 1993, On-the-Levei. Construction has maintained a laleoted posi of cenfifed sutf and indepenident comeitants proving the fexbility and corabined expenitince required to meet the needs of its neacly 300 complated pich: ects in the Denver metropolitan aiea. The feld of optrosios methods that On The tevel Canstriction. is responsible for includes structurat developtnent, heseing and cooling. plumbing, and electicty. The company chasges its cients by biling the hours speot en each contrat. The eocely biling Tate depends on the errployee's posilion accocding to the fild of operoticns (as noted priviausly? Figuie Avk 5 shews a basic report that On-The Level Conotruction forernen would lake to see ever week conceming what propects are being assigned, the overill asipument hours, and the chargas for the angiginent OnhiThe-Leed Construction organites its interea structuce in four pperationsStructure (500), Plumbing fon. Eectricol (502t and Heating and Veotation (503) Each of these operational depurimens can and should hwe many subcontractors whe specialize in that area. On-The-1vel Construction has decided to imyloosent a relstion database model ts truck project details accoriting to project name, hours astigned, and charges por hou for oach jab deseription. Originally. Or-The-tevel Construction decided to let one of is enpleyest handie the construction of the dalabase. However, that employee has not had the time to inpinmant ne project completely. On-The Level Constructian has asked you to take over aed comolete the development of the database. The entities and primary heys for the database hive beeo idencifed in Fiqure AYk.5. The following business rules have been identified. 1. A.job con have many employees assigned but must herve at least one. 2. An emigloyee munt be assigned to one and baly one job numbic. 3. Ait eriblojee can be assigned to work on ose or more projects. 4. A proioct can be assigned to only one omployee but need not oe assigned to any moloyse. Yout fob is to complete the lollowing tasks: 1. Develop and describe the entity relationship diagram 2. Use normalization to ensure the correciness of the tables feelations). 3. Create the database using a personal DeMs package fpreferably Microset Accemy. 4. Use the DBMS patkage to create the baskcrepert in figure Ank.5. FIGURE AYK.S On-The-LevelConstructoso Detail Regont Billing Data On-The-Level Construction Company is a Dether-bered coestriction compary that specializes in subcontracting the development of single-ferly tones, in bunioss since 1998, On-The-Level Construction has maintained a talented poot of certiled aze in and inserpendent consitants pronding ects in the Denver metropolitan ancence required to mest the neest of ta maly 300 conpleled prof. is responsible for includes structurald Thevelioid of eperitos nethods that On-The-tevel Construction The compony charges its clients by billing the heating and cooling alumbing, and electricity. rate depends on the employee's pesition accoring hoss spent on each contract. The houly billing Figure AYK. 5 shows a basic report that on. The teing to the feid of ocericoes fos noced previcushl. week concerning what projects are being the-tewil Coratruction forenes would lise to see every for the assignment. On-The-Level Constg assigned, the oviral anslgaroent hours, and the changes Siructure (500). Plambing (507), Electrical (502) onganiaks as intemal structure in four eperationsoperational departments can and should (502) and Heding and Ventiation (503). fach of these On-The-Level Construction has decided is ingie many subcectracss ato specialize in that area. details according to project name, hours to implement a relatonve denabuse modet to track praject Originally, On-The-Level Construction deectsigned, and charres per hour for each job tescription. of the database. However that eofion decided to let ene of is employess tandle the construction. On-The-Level Construction has ashejoyce has not had the tine so irplenent the project completely. The entities and prim has asked you to take over and conglete the development of the database. The following business keys for the databese tave been idert ted in Fifure Ank. 6 . 1. A job can have many employees arsigned but most have at kast ane. 2. An employee must be assigned to one and anly ore jpb numbe:. 3. An employee can be assigned to work on one or more proincts. 4. A project can be assigned to only one employee but need not be andigned to any employee. Your job is to complete the following lask: 1. Develop and describe the entity relationstip dispram. 2. Use normalization to ansure the correctness of the lables fretarione: 3. Create the databasy ueing a personal DEMS package forelerably Microsoft Accesst. 4. Use the DBMS pockage th create the basic report in Figure Ah 5