The following figure shows an EER diagram for a university dining service organization that provides dining services to a major university.

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.

MENU Menu ID Menu Description Menu Type Served at EVENT Event ID Event Date Event Location Event Time Supervises Contains DISH Dish ID Dish Name Prep Time {Ingredient) WORK SCHEDULE Start Time End Time Position th STAFF Emp ID Name Salary {Skill)