| 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 |
| 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 |
| 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 |
| 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 |
| 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 |