Question: The following figure shows an EER diagram for a restaurant (the reserved tables, seats, waiters, and managers). An employee may be a waiter, a manager,

  1. The following figure shows an EER diagram for a restaurant (the reserved tables, seats, waiters, and managers). An employee may be a waiter, a manager, or others (neither waiter nor manager). Managers manages/supervises waiters. A manager cannot be a waiter at the same time.

This is a conceptual design so that it does not specify primary keys, foreign keys, and associative entities. Use Astah (ER) and develop a logical schema.

Your answer should use dash lines ( - - - ) to represent non-identifying relationships and solid lines ( ) to represent identifying relationships.

 The following figure shows an EER diagram for a restaurant (the

| Uses SEATING Seating ID Nbr of Guests Start Time Date End TimeDate RTABLE RTable Nbr RTable Nbr of Seats RTable Rating EMPLOYEE Employee ID Emp Lname Emp Fname ASSIGNMENT a Start TimeDate End TimeDate Tips Earned WAITER MANAGER Hourly Wage {Specialty} Manages Monthly Salary Manages

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!