Question Using the below describe the entities relationships

Question:

Using the below, describe the entities, relationships, their respective attributes, the primary keys and constraints.

Description:

Romano’s is one of the finest Italian restaurants in the city. It is very popular so you need a reservation. A reservation is made for a specific time, date, and number of people. The reservation also captures the name and phone number of the person making the reservation. Each reservation is assigned a unique reservation number.

There are two categories of reservations: individual reservations and banquet reservations. Additional information captured for individual reservation includes seating preference (inside or patio) and smoking preference (smoking or non smoking). Additional information captured for banquet reservation includes the group name, and the method of payment.

Romano’s has a fixed number of tables. Each table is identified by a unique table number. Each table is further described by a unique free form description such as “located by the North window”, “located near the counter”, “has a view of the flowers”, etc. Each table is classified as a 2-person, 4-person, or 6-person table.

When a reservation is made, Romano associates a specific table number(or several specific table numbers) to the reservation. A table can be utilized several times over the evening for many reservations.

The management structure at Romano’s is hierarchical. There are several restaurant managers who report to Romano. The managers are responsible for managing the Maitre’d and the chefs. The Maitre’d is responsible for managing the waiters, bartenders, and bus personnel. The chefs are responsible for managing the cooks and dishwashers. Each employee working for Romano’s must be classified as either a manager, Maitre’d, waiter, bartender, chef, cook, bus person or dishwasher. Information for each employee includes name, date of birth, and driver’s license number.

When the reservation party arrives, the reservation is assigned to one waiter. If the reservation has multiple tables, only one waiter is assigned. A waiter can be assigned to many reservations during the course of the evening.

The menu at Romano’s is exquisite. Each menu item is identified by a unique item number. Information on each menu item includes item description, prep time and price. Each menu item is classified as “appetizer”, “Entrée”, “dessert”, or “beverage”.

The waiter maintains one or several orders for each reservation. An order shows the menu items ordered and the quantity.

Solution

It’s exact to see that Marriott group is giving area and letting chefs to come out with exciting concepts and creativity. Chef Vishal shared that the point of interest, nowadays is at the brunches, which could be very popular in Mumbai. I desire if our chefs too, in Delhi, recognition more on doing subject brunches, in place of growing quantity of dishes on weekends.

After the initial dialogue on food, records and culture, we decided to meet for dinner at Romano. As ordinary, I reached on time. extraordinarily it turned into nearly complete at eight PM (it opens only for dinner). the instant I entered, I cherished the vicinity! excessive ceiling, stairs that takes you to upper ground. Upstairs turned into like a small personal PDRs that still may be converted as guest sitting location. they have got a chef’s desk too, in which they host one of a kind dinner for their guest. Their wine cellar changed into virtually enchanting.

We began with a glass of prosecco together with some freshly baked bread. Marriott is understood for their knowledge in bakery. We met Romano’s Italian Chef Roberto Zorzoli and he served us the fresh Burrata cheese with hairloom tomato. He shared that that is regionally sourced cheese. It became quiet sparkling and at the same time as tasting, you may really feel the flavour of fresh milk – in reality super and delightful!

Australian lamb shank with gremolata and saffron risotto turned into the dish of the day for me. perfectly cooked shank with outstanding risotto; a complete meal in itself which you may pair with my preferred negroni. The bird balls cooked in tomato sauce ( selfmade ) turned into some other best dish. Chef Roberto has put in his attempt to make this vicinity taking place! His easy but rustic cooking and usage of nearby ingredients and neighborhood produce is commendable.