I have a relational database that is part of a lecturer timetable system. One of the tables is RoomInfo. It contains a primary key Room code, capacity, location, type, and facilities.
It's the facility field that is causing a problem. The system lets lecturers request a room to teach in with multiple facilities from a web form. For example, a lecturer requests a room with a blackboard, whiteboard and computer point. I obviously don't want these three facilities input into the same cell as this will cause problems with using the data.
I really cant think of another way to do this though. If I use a diferent field for each facility a room may have, and the cell values will be yes or no this will leave alot of useless, unused cells in the database.
Can anyone suggest a good way to get around this problem (If you understand the problem. If you do not, I can elaborate
Thanks alot for any help
Anthony