| customer_id | first_name | last_name | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| 3 | Michael | Brown | michael.brown@example.com |
| 4 | Emma | Green | emma.green@example.com |
| reservation_id | restaurant_type | year_of_establishment | customer_id |
|---|---|---|---|
| (→ Restaurants.restaurant_type) | (→ Customers.customer_id) | ||
| 1 | Steakhouse | 1980 | 1 |
| 2 | Steakhouse | 2010 | 2 |
| 3 | Seafood Restaurant | 1980 | 3 |
| 4 | Seafood Restaurant | 2005 | 4 |
| restaurant_id | name | restaurant_type |
|---|---|---|
| 1 | The Steak House | Steakhouse |
| 2 | New York Steak House | Steakhouse |
| 3 | Fresh Fish Corner | Seafood Restaurant |
| 4 | Blue Ocean Delights | Seafood Restaurant |
| year_id | establishment_year |
|---|---|
| 1 | 1980 |
| 2 | 2010 |
| 3 | 2005 |