Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Companys 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.

image text in transcribed

Match each of the following tables from the diagram with the number of the corresponding primary key from the list of primary keys below. Assign 0 to any tables that are not part of the database for this diagram.

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 #
image text in transcribed

image text in transcribed \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Tables } & Primary Keys \\ \hline a. & Projects & \\ \hline b. & Budgets \\ \hline c. & Budget items \\ \hline d. & Labor \\ \hline e. & Equipment & \\ \hline f. & Services & \\ \hline g. & Materials \\ \hline h. & Budget items - Labor & \\ \hline i. & Customers & \\ \hline j. & Budget items - Materials & \\ \hline k. & Budget items - Services & \\ \hline l. & Budget items - Equipment & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{1}{|c|}{ Tables } & \multicolumn{1}{c|}{ Foreign Keys } \\ \hline a. & Projects & \\ \hline b. & Budgets & \\ \hline c. & Budget items & 2,8 \\ \hline d. & Labor & \\ \hline e. & Equipment & \\ \hline f. & Services & \\ \hline g. & Materials & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Tables } & Primary Keys \\ \hline a. & Projects & \\ \hline b. & Budgets \\ \hline c. & Budget items \\ \hline d. & Labor \\ \hline e. & Equipment & \\ \hline f. & Services & \\ \hline g. & Materials \\ \hline h. & Budget items - Labor & \\ \hline i. & Customers & \\ \hline j. & Budget items - Materials & \\ \hline k. & Budget items - Services & \\ \hline l. & Budget items - Equipment & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & \multicolumn{1}{|c|}{ Tables } & \multicolumn{1}{c|}{ Foreign Keys } \\ \hline a. & Projects & \\ \hline b. & Budgets & \\ \hline c. & Budget items & 2,8 \\ \hline d. & Labor & \\ \hline e. & Equipment & \\ \hline f. & Services & \\ \hline g. & Materials & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

12th Edition

0324100949, 978-0324100945

More Books

Students also viewed these Accounting questions

Question

seek winwin conflict resolution outcomes whenever possible

Answered: 1 week ago