## Seating_Areas

AreaID | Name | Number_Of_Seats | Type_of_Food
--- | --- | --- | ---
1 | Patio | 50 | Italian
2 | Patio | 60 | Mexican
3 | Veranda | 50 | Chinese
4 | Veranda | 30 | Indian
5 | Lobby | 20 | American

## Restaurant

RestID | Name | Address | Contact_No | Seating_Area_ID
--- | --- | --- | --- | ---
|  |  |  | (→ Seating_Areas.AreaID)
1 | Ristorante Italiano | 123 Main St | +1 800 1234567 | 1
2 | Taco Town | 456 Elm St | +1 987 6543210 | 2
3 | Wok This Way | 789 Oak St | +1 234 5678901 | 3
4 | Samosa Palace | 135 Pine St | +1 345 6789012 | 4
5 | All American Grill | 987 Birch St | +1 456 7890123 | 5

## MenuItems

ItemID | Name | Category | Price | Description | Restaurant_ID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Restaurant.RestID)
1 | Margherita Pizza | Pizza | 12.99 | Classic Margherita with mozzarella, tomato sauce, basil. | 1
2 | Enchiladas Suizas | Mexican | 10.99 | Three corn tortillas filled with chicken and smothered in a creamy green salsa verde, garnished with sour cream and onions. | 2
3 | Kung Pao Chicken | Chinese | 13.99 | Stir-fried diced chicken breast with peanuts, dried red chili pepper, and vegetables in a spicy Kung Pao sauce. | 3
4 | Biryani | Indian | 11.99 | Aromatic rice dish made with long grain basmati rice, layered with spices and cooked with meat. | 4
5 | Cheeseburger | American | 8.99 | Grilled beef patty served on a sesame seed bun with lettuce, tomatoes, onions, pickles, cheese, and mayonnaise. | 5

## Reservations

ReservationID | Date | Time | No_Of_Guests | Customer_Name | TableID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Seating_Areas.AreaID)
1 | 2022-01-01 18:30 | 5 PM | 4 | John Doe | 1
2 | 2022-01-02 20:00 | 8 PM | 2 | Jane Smith | 2
3 | 2022-01-03 19:30 | 7:30 PM | 6 | Emily Johnson | 3
4 | 2022-01-04 18:00 | 6 PM | 8 | William Brown | 4
5 | 2022-01-05 20:30 | 9 PM | 10 | Olivia Wilson | 5

## Reviews

ReviewID | Rating | Comment | Reservation_ID
--- | --- | --- | ---
|  |  | (→ Reservations.ReservationID)
1 | 5 | Great food, amazing service! | 1
2 | 4 | The ambiance was lovely but I found my meal a bit overpriced. | 2
3 | 3 | Nice place to hang out but could use some improvement on their menu. | 3
4 | 5 | We had an excellent time at this restaurant. The staff were very friendly and attentive. | 4
5 | 4 | Really enjoyed our visit here. We will definitely come back again. | 5