Table Name: ROOMDETAIL DetailID RD01 RD02 RD03 Table Name: ROOM RoomID R1001 R2002 R2005 R3006 R5005 Description 2 single beds 1 king bed 1 super king bed, 1 king bed C104 C105 C106 Name Superior Twin Deluxe Twin Table Name: GUEST GuestID C101 C102 C103 RS1245 RS2501 RS2601 RS3002 Superior King Deluxe King Deluxe Suite GuestName J.Alan P.Amos S.John K.William J.Martin K.Oscar Table Name: RESERVATION Reservation ID R$1001 RS1193 RS1208 RoomID R1001 R2005 R3006 R5005 R2002 R2005 R2005 DetailID RD01 RD01 RD02 RD02 RD03 MaxCapacity 2 2 4 Contact Number 011-6738495 018-3927648 019-3442486 017-9387652 011-5326780 016-2230087 GuestID C102 C105 C103 C101 C102 C103 C102 T Price 199 250 550 CheckInDate 2019-12-02 2019-12-05 2020-01-15 2021-05-09 2021-08-10 2022-01-15 2022-04-08 O CheckOutDate 2019-12-05 2019-12-06 2020-01-16 2021-05-12 2021-08-12 2022-01-17 2022-04-10