## Hours

id | startTime | endTime
--- | --- | ---
1 | 7:30 AM | 4 PM
2 | 8:00 AM | 12 PM

## Buffets

id | name | location | hoursId
--- | --- | --- | ---
|  |  | (→ Hours.id)
1 | Morning Delight | Hotel A Lobby | 1
2 | Gourmet Corner | Conference Center | 2

## CoffeeShops

id | name | location | hoursId
--- | --- | --- | ---
|  |  | (→ Hours.id)
1 | Aroma Cafe | Lobby of Hotel A | 1
2 | Espresso Station | Convention Center | 2

## Restaurants

id | name | location | type | hoursId
--- | --- | --- | --- | ---
|  |  |  | (→ Hours.id)
1 | La Cucina Italiana | Hotel A Ground Floor | Italian | 1
2 | Oriental Palace | Conference Center | Chinese | 2

## Bars

id | name | location | hoursId
--- | --- | --- | ---
|  |  | (→ Hours.id)
1 | The Wine Cellar | Hotel A Basement | 1
2 | Rooftop Bar | Convention Center Top Floor | 2

## Rooms

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