Figure 4-34 (page 197) shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. Your assignment is to:

a. Develop a relational schema.

b. Show the functional dependencies.

c. Develop a set of 3NF relations using an enterprise key.

REFERENCE:

 

Transcribed Image Text:

FIGURE 4-34 EER diagram for a restaurant SEATING Seating ID Nbr of Guests RTABLE RTable Nbr Uses RTable Nbr of Seats RTable Rating Start TimeDate End TimeDate EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wago | (Specialty) Manages Monthly Salary Manages FIGURE 4-34 EER diagram for a restaurant SEATING Seating ID Nbr of Guests RTABLE RTable Nbr Uses RTable Nbr of Seats RTable Rating Start TimeDate End TimeDate EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wago | (Specialty) Manages Monthly Salary Manages