ROOM ADMINISTRATOR ROOM TYPE CUSTOMER Table CUST_ID PK FK NAME PK FK ADDRESS PK FK E-MAIL PK FK CONTACT NO. PK FK PASSWORD PK FK USERNAME PK FK PAYMENT Table PAYMENT_ID PK FK AMOUNT PK FK BOOKING ID PK FK CUSTOMER ID PK FK M1 M2 M3 M4 M1 M2 M3 M4 PAYS RESERVATION Table RESERVATION_ID PK FK ARRIVAL_DATE PK FK DEPARTURE_DATE PK FK BOOKING_STATUS PK FK PAYMENT_ID PK FK GUEST_NO PK FK BOOKING_ID PK FK M1 M2 M3 M4 MAKES M1 M2 M3 M4 RESERVED BY ROOM_NO PK FK ROOM_TYPE PK FK ROOM_FLOOR PK FK HANDLED BY USER_ID PK FK USERNAME PK FK PASSWORD PK FK E-MAIL PK FK TYPE_ID PK FK NAME PK FK MAX GUESTS PK FK TOTAL_ROOMS PK FK ROOM_PRICE PK FK DESCRIPTION PK FK HAS M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4