solve a) b) c)

Question 3. (30 points) The following figure shows an EER diagram for a university dining service organization that provides dining services to a major university. MENU EVENT Menu ID Sonred at Event ID Menu Description fpr | Event Date Menu Type Event Location Event Time DISH WORK SCHEDULE STAFF Dish ID Start Time Emp ID Dish Name End Time Name Prep Time Position Salary {Ingredient} {Skill} 2022 Pearson Education, Inc. a. Transform the EER diagram to a set of relations. b. Diagram the functional dependencies and determine the normal form for each relation. c. Convert all relations to third normal form