Task:
Shoprite grocery stores have the below table for products (with associated functional dependencies). What level of normalization is the table in? (the best level it is in). Explain Why. Produce a new design that is in 3NF, and show all of the records in the resulting tables.
|
SKU |
Brand |
Product |
Color |
Size |
Price |
Distributor |
|
1111 |
Kellogg |
Frosted Flakes |
Blue |
20oz |
3.99 |
KMC Inc |
|
1112 |
Kellogg |
Frosted Flakes |
Blue |
25oz |
4.99 |
KMC Inc |
|
1121 |
Kellogg |
Raisin Bran |
Purple |
20oz |
3.89 |
KMC Inc |
|
1122 |
Kellogg |
Raisin Bran |
Purple |
25 oz |
5.19 |
KMC Inc |
|
1211 |
Shoprite |
Raisin Bran |
Purple |
20oz |
2.99 |
Wakefern |
|
1311 |
Wonder |
Bread |
Brown |
24oz |
2.09 |
KMC Inc |
|
1312 |
Wonder |
Bread |
Brown |
16oz |
1.99 |
KMC Inc |
|
1411 |
Turkey Hill |
Vanilla Ice Cream |
White |
1 gal |
3.99 |
Turkey Inc |
|
1421 |
Turkey Hill |
Choc Ice Cream |
Brown |
1 gal |
3.99 |
Turkey Inc |
Primary Key: SKU
Functional Dependencies:
SKU è Brand
SKU è Product
SKU è Color
SKU è Size
SKU è Price
SKU è Distributor
Brand è Distributor
Product è Color