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

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