Create a table named TBL_ROOM like this
TBL_ROOM
(
ROOM_ID INT,
ROOM_NO INT,
FLOOR_NO INT,
FLOOR_DISPLAY_NAME VARCHAR(20)
);
Store your room information in this table like this
1 11 1 1stFloor
2 12 1 1stFloor
now simply get a join to this table on ROOM_NO, your porblem shoul get resolved.
Thanks