1) Normalize your relational schema and show the steps of converting it into 1NF, 2NF, and 3NF.

In each step:

2) Write down the functional dependencies before refinement, and show how some of them were eliminated so as to give the next level of normalization.

3) Write out the relational schema in the text format that was demonstrated in class.

NOTE: Use capital letters for table names and camel case for attributes. Underline all keys.

Manufacturer ManufacturerlD CompanyName SnackBuyingPrice SName DrinkPriceBuying DName SNACK SnackRetailPrice NumltemsStocked SnackMaxCapacity WeeklyProfitSnackType NumSnackSoldPerWeelk VendinglD (FK) Product Unrefiglnvento ManufacturerlD (FK) VendingID (FK) VendingID (FK) VendingMachine VendinglD Street Cit State ZipCode TotalWeeklyProfit TotalltemsSold EmployeelD (FK) DRINK DrinkMaxCapacity DrinkRetailPrice NumltemsStocked WeeklyProfitDrinkType NumDrinkSoldPerWeek VendingID (FK) Refiglnvento VendingID (FK) Em FirstName LastName Manufacturer ManufacturerlD CompanyName SnackBuyingPrice SName DrinkPriceBuying DName SNACK SnackRetailPrice NumltemsStocked SnackMaxCapacity WeeklyProfitSnackType NumSnackSoldPerWeelk VendinglD (FK) Product Unrefiglnvento ManufacturerlD (FK) VendingID (FK) VendingID (FK) VendingMachine VendinglD Street Cit State ZipCode TotalWeeklyProfit TotalltemsSold EmployeelD (FK) DRINK DrinkMaxCapacity DrinkRetailPrice NumltemsStocked WeeklyProfitDrinkType NumDrinkSoldPerWeek VendingID (FK) Refiglnvento VendingID (FK) Em FirstName LastName