Normalize your relational schema and show the steps of converting it into 1NF, 2NF, and 3NF. In each step, write down the functional dependencies before refinement, and show how some of them were eliminated so as to give the next level of normalization. Write out the relational schema in the text format that was demonstrated in class.

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

Unrefiglnvento VendinglD (FK) SnackID (FK) SNACK SnackID SnackRetailPrice SnackMaxCapacity WeeklyProfitSnackType NumSnackSoldPerWeek SnackName Product MANUFACTURER rl Man CompanyName SnackBuyingPrice SName DrinkPriceBuying DName (FK) VENDING MACHINE VendingID Street City State ZipCode TotalWeeklyProfit TotalltemsSold VendinglD (FK) VendingID (FK) nkID (FK) DRINK DrinklD DrinkMaxCapacity DrinkRetailPrice WeeklyProfitDrinkType NumDrinkSoldPerWeek DrinkName EMPLOYEE eelD (FK) Employeel FirstName LastName