HotelID | Name | Location |
---|---|---|
1 | Grand Plaza | Downtown |
2 | Park View Inn | Suburb |
3 | Coastal Paradise | Beachside |
4 | Mountain Retreat | Mountains |
5 | City Center Suites | Central Business District |
ServiceID | ServiceName |
---|---|
1 | Housekeeping |
2 | Restaurant |
3 | Gym |
4 | Concierge |
5 | Laundry |
Hotels_ID | Service_ID |
---|---|
(→ Hotels.HotelID) | (→ Services.ServiceID) |
1 | 2 |
1 | 3 |
1 | 4 |
1 | 5 |
2 | 1 |
2 | 3 |
2 | 4 |
2 | 5 |
3 | 1 |
3 | 2 |
3 | 4 |
3 | 5 |
4 | 1 |
4 | 2 |
4 | 3 |
4 | 5 |
5 | 1 |
5 | 2 |
5 | 3 |
5 | 4 |
5 | 5 |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |