(Answered): 1. (10pts) The following figure shows an EER diagram for a restaurant, its tables, and the waiters ...

1. (10pts) The following figure shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. NOTE : In the EMPLOYEE entity, you can assume an additional attribute EmpType that serves as subtype discriminator. Transform the EER diagram into a 3NF relation schema and show all the dependencies. Uses SEATING Seating ID Nbr of Guests Start TimeDate End TimeDate RTABLE RTable Nbr RTable Nbr of Seats RTable Rating EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wage (Specialty Manages Monthly Salary Manages