id | Name | Type | Year_of_Establishment |
---|---|---|---|
1 | Fine Steaks | Steakhouse | 1980 |
2 | The Rib House | Steakhouse | 2005 |
3 | Surfside Seafood | Seafood Restaurant | 1980 |
4 | Coastal Catch | Seafood Restaurant | 2010 |
id | FirstName | LastName | Position | RestaurantId |
---|---|---|---|---|
(→ Restaurants.id) | ||||
1 | John | Doe | Manager | 1 |
2 | Jane | Smith | Waiter | 1 |
3 | Bob | Johnson | Chef | 2 |
4 | Alice | Williams | Hostess | 3 |
id | ItemName | Description | Price | RestaurantId |
---|---|---|---|---|
(→ Restaurants.id) | ||||
1 | T-bone Steak | A delicious T-bone steak with garlic butter. | 35.99 | 1 |
2 | Shrimp Scampi | Grilled shrimps sauteed with white wine, garlic and parsley. | 20.99 | 3 |
3 | Garlic Bread | Crusty bread baked with lots of freshly minced garlic. | 6.99 | 4 |
4 | Mixed Greens Salad | A refreshing salad with a variety of mixed greens, cherry tomatoes, cucumber and feta cheese. | 8.99 | 2 |
id | CustomerName | ContactNumber | NumInParty | Date | Time | RestaurantId |
---|---|---|---|---|---|---|
(→ Restaurants.id) | ||||||
1 | Alex Johnson | +1234567890 | 4 | 2022-06-15 | 19:00:00 | 1 |
2 | Emily Smith | +1234567891 | 2 | 2022-06-17 | 20:00:00 | 2 |
3 | Chris Brown | +1234567892 | 6 | 2022-06-18 | 18:00:00 | 3 |
4 | Kelly Clarkson | +1234567893 | 8 | 2022-06-19 | 17:00:00 | 4 |