Problem II - (20 points)

Use the process of normalization to transform the table below into 3NF. Show the tables in 1NF and 2NF that are created in the process.

Owner ID	Owner Name	Owner Address	Owner Automobiles(s)
100	Smith	Salt Lake City	Ford, Honda
101	Jones	Phoenix	Ford
102	Lee	Denver	Toyota
104	Smith	Salt Lake City	Chevrolet

Problem III - (15 points)

Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from many vendors. The bakery has commercial customers, such as schools and restaurants, that regularly place orders for baked goods. Each baked good has a specialist that oversees the setup of the bakery operation and inspects the finished product.

Problem IV - (20 points)

Interglobal Paper Company has asked for your help in comparing its present computer system with a new one its board of directors would like to see implemented. Proposed system and present system costs are as follows:

Year Proposed System Costs Present System Costs

Year 1

Equipment Lease $20,000 $21,500

Salaries 30,000 50,000

Overhead 4,000 13,000

Development 30,000

Year 2

Equipment Lease $20,000 $10,500

Salaries 23,000 55,000

Overhead 4,400 3,300

Development 12,000

Year 3

Equipment Lease $20,000 $10,500

Salaries 36,000 60,000

Overhead 4,900 3,600

Development

Year 4

Equipment Lease $20,000 $10,500

Salaries 39,000 66,000

Overhead 5,500 4,000

Development

a. Using break-even analysis, determine the year in which Interglobal Paper will break even.

b. Graph the costs and show the break-even point.