Question
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.
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.)
- Project #
- Budget #
- Budget item #
- Employee #
- Customer #
- Labor category #
- Equipment category #
- Services category #
- Materials type #
- Budget item # + Labor category #
- Budget item # + Equipment category #
- Budget item # + Services category #
- Budget item # + Materials type #
- Budget # + Budget item #
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started