Use the process of normalization to transform the table


Problem I -

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 II-

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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Use the process of normalization to transform the table
Reference No:- TGS02898434

Expected delivery within 24 Hours