Restaurants

restaurant_idnameaddressphone_numbercocktail_lounge_idsports_bar_idhours
(→ Cocktail_Lounges.lounge_id)(→ Sports_Bars.bar_id)
1The Fancy Bistro123 Main St555-12341NoneMonday - Friday: 8AM - 10PM
2Cozy Cafe456 Elm St555-567821Open 24 Hours
3Beer Haven789 Maple Ave555-901232Monday - Thursday: 4PM - 2AM, Friday - Saturday: Noon - 2AM, Sunday: Closed
4Italian Delight321 Oak St555-1357None4Tuesday - Thursday: 11AM - 10PM, Friday & Saturday: 11AM - Midnight, Sunday & Monday: Closed

Cocktail_Lounges

lounge_idnameaddressphone_numberhours
1Martini Nights135 Pine St555-5670open from 5 PM to 2 AM
2Rooftop Rendezvous456 Willow St555-1235open from 4 PM to midnight
3Gatsby Lounge789 Birch St555-1356open from noon to 2 AM
4Exotic Oasis321 Palm St555-1457open from 10 AM to 1 AM

Sports_Bars

bar_idnameaddressphone_numberhours
1Gridiron Grill555 Oak Plaza555-9876open from 5 PM to 2 AM
2Slam Dunk Saloon678 Pine Blvd555-1236open from 4 PM to midnight
3Kickback Tavern987 Spruce Way555-1358open from noon to 2 AM
4Home Run Bar345 Elm Terrace555-1458open from 10 AM to 1 AM

Employees

employee_idfirst_namelast_namepositionrestaurant_id
(→ Restaurants.restaurant_id)
1JohnDoeManager1
2JaneSmithWaitress1
3TomBrownChef1
4AliceJohnsonHostess2
5BobWilliamsServer2
6CharlieMillerBusser3
7DavidWilsonHead Chef3
8EvaJacksonServer4
9FrankThompsonBartender4