please help.

3/2016 MeGW HI Connect Ebook The entity danses and primary kays for the database have been identified as the following: Project Project Rumber Employee Nur Job Number Ass Number kod The following business rules have also 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 jab number. 3. An employee can be assigned to work on one or more projects. 4. A project can be assigned to one or many employees. Your job is to be completed in the following phases: 1. Develop and describe the entity-relationship diagram. 2. Use normalization to assure 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 GP.1 SOME PARTICULARS YOU SHOULD KNOW 1. You may not be able to develop a report that looks exactly like the one in Figure GP1 However, your report should include the same information. 2. Complete personnel information is tracked by another database. For this application, include only the minimum employee number, last name, and First name, 3. Information concerning all projects, employees and jobs is not readily available. You should, however, create information for several fictitious systems to include in your database. 4. FB: Not applicable. CASE 3: UBING RELATIONAL TECHNOLOGY TO TRACK PROJECTS FOOTHILLS CONSTRUCTION Foothie Construction Company is a Derwer-based action com that specializes in subcontracting the development of single fondy homes. In business since 1993. Foothes Contraction Company has maintained a talented pool of entired stall and independent con Blowing the flexbility and combined experience required to meet the neede of the nearly 300 completed projects in the Denver area. The fold of operation methods that Foothills Constructions responsible for os rolatus to building Indude uchrader heating and cooling, plumbing, and electricity The company chores do clients by being the hours spent on och contract. The hourly willing rato dependent on hemoloyee's por lo according to the field of operations (as noted below) Figure GPad shows a basic report that Foothes Construction managers would to see every wok concerning what projects we berg assigned as well as a summary of assignment hout changes Foothills Construction organizes its internal structure for det operations Structure (500). Plumbing (501). Electrical (502) and Heating and Ventilation (503). Each of these operational or can and should have many subcontractors who specialitetan Figure GP1 Foothes Construction Project Detail POOTHILLS CONSTRUCTION PROJECT DETAIL Bele olie boom in over the last van Foones ha decidido entrega calabon mode Tek toe ding om hunned, and router Nota description Only Foots con decided to let us emely and the construction Habae. However, we had to entitet och stofnked W Hokeovee compete the decemento estina Sevibe US MYDOORS This course Benjamin Development of Entity Diagram: Before" picture is correct and accurate (minimum and maximum cardinalities are correctly depicted) "After picture is correct and accurate intersection relation is correctly defined and the minimum and maximum cardinalities are correctly depicted (8) Created tables in Access: List tables with the database structure in 3rd normal form: Assign Table: (2) Primary key is correctly defined Included proper fields Employee table: (2) Primary key is correctly defined Included proper fields Job table:(2) Primary key is correctly defined Included proper fields Project table: (2) Primary key is correctly defined Included proper fields Created a query and used the expression builder to insert a calculated field multiplying number of hours and cost per hour (4) Created a report based on the query that included the proper fields. The report is grouped properly. The summary options were chosen BORT The grand total near All numbers are the order of bed is identical to the order of fields on the report in the text MacBook Pro Created a query and used the expression builder to insert a calculated field multiplying number of hours and cost per hour.(4) Created a report based on the query that included the proper fields. The report is grouped properly. The summary options were chosen properly. The grand total appears. All numbers are accurate. The order of fields is identical to the order of fields on the report in the text. (10) ***Important steps of the assignment: 1. Read case 5 in its entirety. See Moodle. 2. creation of E-R diagram (all steps) 3. listing of tables and fields in each (identifying primary keys and foreign keys as you create the listing) 4. ensure that your database structure is in 3rd normal form 5. Steps 1-4 should be handwritten and then scanned. Save scanned document as pdf for posting to Moodle. 6. creation of tables in Microsoft Acess 7. establish relationships in Access 8. creation of query that contains all fields that are present in figure GP.1 and one calculated field (hint: use a calculated field to get the summary of assignment hours and charges) 9. creation of Report that is based on the query): "Foothills Construction Project Detail," generated by MS Access, and which looks like the report shown in Figure GP.1. Again, a pdf file that contains you E-R diagram and your listing of tables with identification of primary and foreign keys (and other fields) should be created. By downloading an app to your phone that allows you to scan, you can easily take pictures of written work and save as a pdf file. In addition, you will need to create the Access database. These two files need to be saved in a compressed (zipped) folder. This zipped folder must be submitted to me by each group by the due date specified on the course schedule. I do not wish to receive submissions by each person only one submission per group, please. PROJECT FOOTHILLS CONSTRUCTION PROJECT DETAIL ASSIGN DATE EMP LAST NAME EMPFIRST NAME JOB DESCRIPTION ASSIGN HOUR CHARGE OUR PROJECT NAME Chatida Thursday, February 1 2005 Jones Anne Keating and Writiation Electrical Sutivan David 18 5105.00 Frommer Plumbing 2 $0.75 Thursday, February 10, 2005 Foday, Februay 11, 2005 Saturday, February 12, 2005 Saturday, February 12 2005 Newman John 02 Electrical Plumbing 505.00 306.75 Bawang Terry 15.10 $1.4835 wat Strudur 30 3575 Snted Newman 3 Electric 3105.00 Sum of Assignment on and Charges Evergreen Thursday, February 10, 2005 Thursday, February 10, 2005 Thursday, February 10, 2005 stay, February 11, 2006 Saturday Feb. 12. 2005 Besday, February 12, 2005 G. 2005 Days S675 Plus and en 26 5845 Pele lector Ciclo 31059 51050 Newman De Olen De 1 53995 100 1.643.65 Summary of Archer Roxborough 3/2016 MeGW HI Connect Ebook The entity danses and primary kays for the database have been identified as the following: Project Project Rumber Employee Nur Job Number Ass Number kod The following business rules have also 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 jab number. 3. An employee can be assigned to work on one or more projects. 4. A project can be assigned to one or many employees. Your job is to be completed in the following phases: 1. Develop and describe the entity-relationship diagram. 2. Use normalization to assure 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 GP.1 SOME PARTICULARS YOU SHOULD KNOW 1. You may not be able to develop a report that looks exactly like the one in Figure GP1 However, your report should include the same information. 2. Complete personnel information is tracked by another database. For this application, include only the minimum employee number, last name, and First name, 3. Information concerning all projects, employees and jobs is not readily available. You should, however, create information for several fictitious systems to include in your database. 4. FB: Not applicable. CASE 3: UBING RELATIONAL TECHNOLOGY TO TRACK PROJECTS FOOTHILLS CONSTRUCTION Foothie Construction Company is a Derwer-based action com that specializes in subcontracting the development of single fondy homes. In business since 1993. Foothes Contraction Company has maintained a talented pool of entired stall and independent con Blowing the flexbility and combined experience required to meet the neede of the nearly 300 completed projects in the Denver area. The fold of operation methods that Foothills Constructions responsible for os rolatus to building Indude uchrader heating and cooling, plumbing, and electricity The company chores do clients by being the hours spent on och contract. The hourly willing rato dependent on hemoloyee's por lo according to the field of operations (as noted below) Figure GPad shows a basic report that Foothes Construction managers would to see every wok concerning what projects we berg assigned as well as a summary of assignment hout changes Foothills Construction organizes its internal structure for det operations Structure (500). Plumbing (501). Electrical (502) and Heating and Ventilation (503). Each of these operational or can and should have many subcontractors who specialitetan Figure GP1 Foothes Construction Project Detail POOTHILLS CONSTRUCTION PROJECT DETAIL Bele olie boom in over the last van Foones ha decidido entrega calabon mode Tek toe ding om hunned, and router Nota description Only Foots con decided to let us emely and the construction Habae. However, we had to entitet och stofnked W Hokeovee compete the decemento estina Sevibe US MYDOORS This course Benjamin Development of Entity Diagram: Before" picture is correct and accurate (minimum and maximum cardinalities are correctly depicted) "After picture is correct and accurate intersection relation is correctly defined and the minimum and maximum cardinalities are correctly depicted (8) Created tables in Access: List tables with the database structure in 3rd normal form: Assign Table: (2) Primary key is correctly defined Included proper fields Employee table: (2) Primary key is correctly defined Included proper fields Job table:(2) Primary key is correctly defined Included proper fields Project table: (2) Primary key is correctly defined Included proper fields Created a query and used the expression builder to insert a calculated field multiplying number of hours and cost per hour (4) Created a report based on the query that included the proper fields. The report is grouped properly. The summary options were chosen BORT The grand total near All numbers are the order of bed is identical to the order of fields on the report in the text MacBook Pro Created a query and used the expression builder to insert a calculated field multiplying number of hours and cost per hour.(4) Created a report based on the query that included the proper fields. The report is grouped properly. The summary options were chosen properly. The grand total appears. All numbers are accurate. The order of fields is identical to the order of fields on the report in the text. (10) ***Important steps of the assignment: 1. Read case 5 in its entirety. See Moodle. 2. creation of E-R diagram (all steps) 3. listing of tables and fields in each (identifying primary keys and foreign keys as you create the listing) 4. ensure that your database structure is in 3rd normal form 5. Steps 1-4 should be handwritten and then scanned. Save scanned document as pdf for posting to Moodle. 6. creation of tables in Microsoft Acess 7. establish relationships in Access 8. creation of query that contains all fields that are present in figure GP.1 and one calculated field (hint: use a calculated field to get the summary of assignment hours and charges) 9. creation of Report that is based on the query): "Foothills Construction Project Detail," generated by MS Access, and which looks like the report shown in Figure GP.1. Again, a pdf file that contains you E-R diagram and your listing of tables with identification of primary and foreign keys (and other fields) should be created. By downloading an app to your phone that allows you to scan, you can easily take pictures of written work and save as a pdf file. In addition, you will need to create the Access database. These two files need to be saved in a compressed (zipped) folder. This zipped folder must be submitted to me by each group by the due date specified on the course schedule. I do not wish to receive submissions by each person only one submission per group, please. PROJECT FOOTHILLS CONSTRUCTION PROJECT DETAIL ASSIGN DATE EMP LAST NAME EMPFIRST NAME JOB DESCRIPTION ASSIGN HOUR CHARGE OUR PROJECT NAME Chatida Thursday, February 1 2005 Jones Anne Keating and Writiation Electrical Sutivan David 18 5105.00 Frommer Plumbing 2 $0.75 Thursday, February 10, 2005 Foday, Februay 11, 2005 Saturday, February 12, 2005 Saturday, February 12 2005 Newman John 02 Electrical Plumbing 505.00 306.75 Bawang Terry 15.10 $1.4835 wat Strudur 30 3575 Snted Newman 3 Electric 3105.00 Sum of Assignment on and Charges Evergreen Thursday, February 10, 2005 Thursday, February 10, 2005 Thursday, February 10, 2005 stay, February 11, 2006 Saturday Feb. 12. 2005 Besday, February 12, 2005 G. 2005 Days S675 Plus and en 26 5845 Pele lector Ciclo 31059 51050 Newman De Olen De 1 53995 100 1.643.65 Summary of Archer Roxborough