Seating_Areas

AreaIDNameNumber_Of_SeatsType_of_Food
1Patio50Italian
2Patio60Mexican
3Veranda50Chinese
4Veranda30Indian
5Lobby20American

Restaurant

RestIDNameAddressContact_NoSeating_Area_ID
(→ Seating_Areas.AreaID)
1Ristorante Italiano123 Main St+1 800 12345671
2Taco Town456 Elm St+1 987 65432102
3Wok This Way789 Oak St+1 234 56789013
4Samosa Palace135 Pine St+1 345 67890124
5All American Grill987 Birch St+1 456 78901235

MenuItems

ItemIDNameCategoryPriceDescriptionRestaurant_ID
(→ Restaurant.RestID)
1Margherita PizzaPizza12.99Classic Margherita with mozzarella, tomato sauce, basil.1
2Enchiladas SuizasMexican10.99Three corn tortillas filled with chicken and smothered in a creamy green salsa verde, garnished with sour cream and onions.2
3Kung Pao ChickenChinese13.99Stir-fried diced chicken breast with peanuts, dried red chili pepper, and vegetables in a spicy Kung Pao sauce.3
4BiryaniIndian11.99Aromatic rice dish made with long grain basmati rice, layered with spices and cooked with meat.4
5CheeseburgerAmerican8.99Grilled beef patty served on a sesame seed bun with lettuce, tomatoes, onions, pickles, cheese, and mayonnaise.5

Reservations

ReservationIDDateTimeNo_Of_GuestsCustomer_NameTableID
(→ Seating_Areas.AreaID)
12022-01-01 18:305 PM4John Doe1
22022-01-02 20:008 PM2Jane Smith2
32022-01-03 19:307:30 PM6Emily Johnson3
42022-01-04 18:006 PM8William Brown4
52022-01-05 20:309 PM10Olivia Wilson5

Reviews

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