please write a scenario for this system
reference:https://www.vertabelo.com/blog/technical-articles/designing-a-data-model-for-a-hotel-room-booking-system
ineed to write a senario for a data base system (hotel manegment)then transfer it to ER digramthis is data base coursereservation id date in date made by guest id varchar(20) tatus guest id ivt varchan 80) varchar(80)N date member_since room_type id descriptionvarchar(80) hosted at id guest id occupied_room_id int PK room occupied room varchar(10) number check in 0name EK BK varchar(10) ins int status room id reservation id room type Show
OR
OR