| 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 |