Required Information Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer the associated questions: The Pacific Construction Company's construction projects required careful planning. Each project has a budget. The budget is established within a few weeks after the project is authorized. A budget is composed of many budget items. Each budget item could include labor cost estimates, equipment cost estimates, service cost estimates, or materials cost estimates. Labor costs are estimated by identifying the types of employees that will work on each project, the labor rates for that type of employee, and the expected hours required. Equipment costs are similarly estimated by identifying the type of equipment, costs, and hours. Services costs are broadly estimated by type of service and expected total cost. Materials costs are estimated by type of material, quantity required, and expected cost. A budget item could combine multiple types of labor. equipment, or materials, but it would include only one type of service. A budget item would include only labor, or equipment, or services, or materials. Labor, equipment, services, and materials information is recorded before use to form budgets. 1..1 H A. Project Budget 1..1 F 0.. B. E 0.. D 0.. H 0.. Labor Equipment Services C. Match each of the following tables with the number of a primary key or keys from the list of primary keys below that would be posted in the table as a foreign key. Assign 0 to any tables that that do not have foreign keys. Table Chas been completed as an example. Possible primary keys (+ indicates number) (If there are multiple primary keys associated with a table, ensure to select the number from the dropdown that corresponds to all related keys.) 1. Project 2. Budget # 3. Budget item : 4. Employee # 5. Customer 6. Labor category # 7. Equipment category 8. Services category 9. Materials type 10. Budget item # + Labor category # 11. Budget item # + Equipment category # 12. Budget item # - Services category # 13. Budget item : - Materials type = 14. Budget # - Budget item Foreign Keys a. b. c. Tables Projects Budgets Budget items Labor Equipment Services 2,8 d. e. f. 9. Materials Required Information Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer the associated questions: The Pacific Construction Company's construction projects required careful planning. Each project has a budget. The budget is established within a few weeks after the project is authorized. A budget is composed of many budget items. Each budget item could include labor cost estimates, equipment cost estimates, service cost estimates, or materials cost estimates. Labor costs are estimated by identifying the types of employees that will work on each project, the labor rates for that type of employee, and the expected hours required. Equipment costs are similarly estimated by identifying the type of equipment, costs, and hours. Services costs are broadly estimated by type of service and expected total cost. Materials costs are estimated by type of material, quantity required, and expected cost. A budget item could combine multiple types of labor. equipment, or materials, but it would include only one type of service. A budget item would include only labor, or equipment, or services, or materials. Labor, equipment, services, and materials information is recorded before use to form budgets. 1..1 H A. Project Budget 1..1 F 0.. B. E 0.. D 0.. H 0.. Labor Equipment Services C. Match each of the following tables with the number of a primary key or keys from the list of primary keys below that would be posted in the table as a foreign key. Assign 0 to any tables that that do not have foreign keys. Table Chas been completed as an example. Possible primary keys (+ indicates number) (If there are multiple primary keys associated with a table, ensure to select the number from the dropdown that corresponds to all related keys.) 1. Project 2. Budget # 3. Budget item : 4. Employee # 5. Customer 6. Labor category # 7. Equipment category 8. Services category 9. Materials type 10. Budget item # + Labor category # 11. Budget item # + Equipment category # 12. Budget item # - Services category # 13. Budget item : - Materials type = 14. Budget # - Budget item Foreign Keys a. b. c. Tables Projects Budgets Budget items Labor Equipment Services 2,8 d. e. f. 9. Materials
