[Solved]Room Reservation Hotel Roomid Pk Roomtype Guest Id Resnr Res Nr Pkeki Ot De Hotel Code Roo Q37209624

i need to create a question for this ER diagram( hotelmanagement system) .

Room Reservation HOTEL ROOM_ID(PK) ROOM_TYPE GUEST ID RES_NR RES NR (PK.EKI OT DE HOTEL CODE ROOM_TYPE ROOM_ID(FK) HOTEL_NAME LOCATION NUM ROOMS Bill Guest Employees INVOICE NR (PK) GUEST ID_NUM (FK) ROOM CHARGE MISC_ CHARGES PK,FK EMPLOYEE ID NAME LAST NAME PHONE RES NR (PK.EKI NAME LAST_NAME PHONE ADDRESS ROOM Show transcribed image text Room Reservation HOTEL ROOM_ID(PK) ROOM_TYPE GUEST ID RES_NR RES NR (PK.EKI OT DE HOTEL CODE ROOM_TYPE ROOM_ID(FK) HOTEL_NAME LOCATION NUM ROOMS Bill Guest Employees INVOICE NR (PK) GUEST ID_NUM (FK) ROOM CHARGE MISC_ CHARGES PK,FK EMPLOYEE ID NAME LAST NAME PHONE RES NR (PK.EKI NAME LAST_NAME PHONE ADDRESS ROOM

Expert Answer

---

Answer to Room Reservation HOTEL ROOM_ID(PK) ROOM_TYPE GUEST ID RES_NR RES NR (PK.EKI OT DE HOTEL CODE ROOM_TYPE ROOM_ID(FK) HOTEL… . . .