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.