## Restaurants

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

## Staff

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

## MenuItems

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

## Reservations

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