Hotel

idNamePriceRoomTypeNumberOfRooms
1Grand Plaza50.0Deluxe100
2Parkside Inn60.0Standard80
3Cozy Corner Motel70.0Economy20
4Downtown Suites90.0Luxury30

Youth_hostel

idNamePriceBedsAvailableFacilities
1Backpackers Haven50.050Kitchen, TV Lounge
2World Wanderer Hostel60.030Common Kitchen, Laundry

Reservation

idCheckInCheckOutTotalAmountPaymentMethod
12022-08-10 14:002022-08-15 11:00300.0Credit Card
22022-08-20 10:002022-08-25 16:00400.0PayPal
32022-09-01 12:002022-09-06 09:00250.0Bank Transfer

Guest

idFirstNameLastNamePhoneNumberEmail
1JohnSmith+1234567890johnsmith@email.com
2JaneDoe+9876543210janedoe@email.com