I am in the process of making a database for booking rooms. There are for, and for arguments sake I will call them room1, room2, room3, and room4.
When somebody books a room, the details of the person and the date they have booked is stored in one table, and the room they have been allocated...