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 |