RoomType

IDTypeName
1Deluxe Suite
2Executive Suite
3Standard Double
4Premium Twin
5Luxury Triple

Booking

IDCustomerIDCheckInDateCheckOutDateTotalAmount
(→ Customer.ID)
112023-01-012023-01-071000
222023-01-152023-01-21900
332023-02-012023-02-07600
442023-02-152023-02-21500
552023-03-012023-03-07800

PricePerNight

IDRoomTypeIDPrice
(→ RoomType.ID)
11150
22200
33150
44200
55150

FamilySuites

IDRoomNumberCapacityAmenities
(→ PricePerNight.ID)
115WiFi, Mini Fridge, Balcony
225No WiFi, No Mini Fridge, No Balcony
335WiFi, Mini Fridge, Balcony
445No WiFi, No Mini Fridge, No Balcony
555WiFi, Mini Fridge, Balcony

SingleRooms

IDRoomNumberCapacityAmenities
(→ PricePerNight.ID)
111WiFi, Mini Fridge, Balcony
221No WiFi, No Mini Fridge, No Balcony
331WiFi, Mini Fridge, Balcony
441No WiFi, No Mini Fridge, No Balcony
551WiFi, Mini Fridge, Balcony

Customers

IDNameContactInfo
1John Doe+1234567890
2Jane Smith+9876543210
3Michael Johnson+0987654321
4Emily Davis+1357924680
5David Wilson+2468013579