2. Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer the associated questions:

The Nordic Construction Companys construction projects require 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 and 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 (these are attributes)expected hours required. Materials costs are estimated by type of material and expected total cost. A budget item could combine multiple types of labor, but it would include only one type of material. A budget item could include only labor or only materials. Labor and materials information is recorded before use to form budgets. Class diagram, showing boxes with 1..* which are the foreign and primary keys

3. Based on the UML class diagram from item 2, above, map the class diagram into tables, assign primary and foreign keys, and map the associations with the multiplicities.

Here is what I have so far. Does this answer the objectives in the questions above? Should I had something and are my answers correct?

Project project 1 budget p. 134 Budget items 10..* Labor Materials #3 project . . 18 project name project budget Budget items Budget item Material type Materal price Labor type Labor prite 0..*. Labor 9 employee type, employee pay rate hours needed employee name 0.. Matenals type material matenal ID# matenalence of Project project 1 budget p. 134 Budget items 10..* Labor Materials #3 project . . 18 project name project budget Budget items Budget item Material type Materal price Labor type Labor prite 0..*. Labor 9 employee type, employee pay rate hours needed employee name 0.. Matenals type material matenal ID# matenalence of