| id | startTime | endTime |
|---|---|---|
| 1 | 7:30 AM | 4 PM |
| 2 | 8:00 AM | 12 PM |
| id | name | location | hoursId |
|---|---|---|---|
| (→ Hours.id) | |||
| 1 | Morning Delight | Hotel A Lobby | 1 |
| 2 | Gourmet Corner | Conference Center | 2 |
| id | name | location | hoursId |
|---|---|---|---|
| (→ Hours.id) | |||
| 1 | Aroma Cafe | Lobby of Hotel A | 1 |
| 2 | Espresso Station | Convention Center | 2 |
| id | name | location | type | hoursId |
|---|---|---|---|---|
| (→ Hours.id) | ||||
| 1 | La Cucina Italiana | Hotel A Ground Floor | Italian | 1 |
| 2 | Oriental Palace | Conference Center | Chinese | 2 |
| id | name | location | hoursId |
|---|---|---|---|
| (→ Hours.id) | |||
| 1 | The Wine Cellar | Hotel A Basement | 1 |
| 2 | Rooftop Bar | Convention Center Top Floor | 2 |
| id | hotelId | roomNumber | price |
|---|---|---|---|
| (→ Hotels.id) | |||
| 1 | 1 | Room 101 | 199.99 |
| 2 | 2 | Suite 202 | 299.99 |
| 3 | 1 | Family Suite | 249.99 |
| 4 | 2 | Corner Room | 269.99 |
| 5 | 1 | Deluxe King | 199.99 |