PART B - Exercises (Answer ALL questions for a total of 70 marks) QUESTION 1 - Database Design using Normalization (20 marks) Normalize the following unnormalized relation. Show all the functional and any multi-valued dependencies between the attributes. Indicate the primary keys, foreign keys, and referential integrity constraints for each relation that should be in 4 N.F. Make and state assumptions as necessary. RESTAURANTI CheflochName CEName, CPhone Assistanti. Al. Name, AF Nams, Resire No RDescription TimeNeeded IngredientiD, IName, Quantity) The above relation includes data that describes the work done in a certain restaurant. The restaurant employs a number of chefs and assistants. An assistant may work with one or more chefs. Recipes are prepared by chefs who may sometimes work together on a recipe. For each recipe we need to keep the quantity used for each of its ingredients