Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    11

    Help designing table with large variety of options

    I am creating a lecture room booking system for a university assignment. Lecturers will be able to choose rooms with specific capacity, in specific locations with specific facilities via a website, and booking and room information will be stored in a database.

    At the moment I am designing the database but I am a little bit unsure as to how to deal with the large variety of options for facilities.
    Here are the tables I have so far:

    ROOM
    Room number, Building, Capacity

    BUILDING
    Building number, Building name, Number of rooms, Park

    PARK
    Park name, number of buildings

    MODULE
    Module code, Module title, Department

    BOOKING
    Room number, Module Code, Semester, Week, Weekday, Timeslot, Lecture Type

    These are all fine I THINK (but please tell me what you think). Now there are a lot of different facilities that a room can have, and I'd like a good way of structuring it. Here is a start, but the list of options goes on and surely there is a better way of doing it. The options will all be a yes/no option

    FACILITIES
    Room number, Computer, Projector,Video/DVD, Visualizer, Whiteboard / Blackboard, PA, Radio Mic, Review, Wheelchair Access, Induction Loop etc

    Any suggestions? Thanks
    Last edited by svedebo; 12-18-12 at 18:28. Reason: Better description of problem

  2. #2
    Join Date
    May 2012
    Posts
    11
    I found a solution

    I have a table called facilities with fields
    facility_id , facility_name

    Then a second table called room_facilities_link with fields
    rfl_id , room_code , facility_id


  3. #3
    Join Date
    Jul 2012
    Posts
    40

    Here are some useful links

    Hi

    These Data Models on my Database Answers Web Site might give you some insights :-

    Generic reservations - Generic Reservations Data Model

    Conference Centers -
    Conference Centers Data Model

    HTH

    Barry Williams
    London

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •