Question

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. SEATING Seating ID Nbr of Guests Start TimeDate End TimeDate RTABLE Uses RTable Nbr RTable Nbr of Seats RTable Rating ASSIGNMENT Start TimeDate End TimeDate Tips Earned EMPLOYEE Employee ID Emp Lname Emp Fname d WAITER Hourly Wage {Specialty} Manages MANAGER Monthly Salary Manages

          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.
SEATING
Seating ID
Nbr of Guests
Start TimeDate
End TimeDate
RTABLE
Uses
RTable Nbr
RTable Nbr of Seats
RTable Rating
ASSIGNMENT
Start TimeDate
End TimeDate
Tips Earned
EMPLOYEE
Employee ID
Emp Lname
Emp Fname
d
WAITER
Hourly Wage
{Specialty}
Manages
MANAGER
Monthly Salary
Manages

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.
SEATING
Seating ID
Nbr of Guests
Start TimeDate
End TimeDate
RTABLE
Uses
RTable Nbr
RTable Nbr of Seats
RTable Rating
ASSIGNMENT
Start TimeDate
End TimeDate
Tips Earned
EMPLOYEE
Employee ID
Emp Lname
Emp Fname
d
WAITER
Hourly Wage
Specialty
Manages
MANAGER
Monthly Salary
Manages

Added by Daniel W.

Question

Please give Ace some feedback