Room Booking System
Jonas Sidborn, Daniel Wiberg, Jan Öhman, and Per Öhman
Department of Computer Science
Umeå University, Sweden
{c01jsn, c00dwg, c01jon, c01pro}@cs.umu.se
Abstract.
The management and booking of rooms in large buildings is
a tedious and complicated task. The combination of dierent rooms with
dierent sizes and equipment, the possibility to choose between dierent
dates and times is the reason why a good booking system is needed to
make this task as easy as possible. A system that supports reservations
of rooms in conference buildings or universities or other large buildings.
This article shows how a complicated human task like reservations can
be solved by using a database management system as the key tool in the
development. The prototype shows an example how such a system could
look like.
1 Introduction
The management and booking of rooms in large buildings is a tedious and com-
plicated task. The combination of dierent rooms with dierent sizes and equip-
ment, the possibility to choose between dierent dates and times is the reason
why a good booking system is needed to make this task as easy as possible.
The basic functionality of the system is to keep track of rooms in dierent
buildings, rooms and their equipment, reservations of rooms and dierent types
of users. Reservations of the rooms should be visualized to the user in a simple
and intuitive way. There should be a simple way of getting a overview of the
reservations. The system should be interoperable with any platform and OS.
A booker should be able to reserve and cancel his/her own bookings and
should be able to search for a room with a certain property like size, price,
number of seats and equipment. There should be an administrator that can
administrate the whole system through the interface without writing any SQL-
queries. This includes the management of add, edit and delete functions for every
entity in the system including new users and their privilege management. One
type of user should only be able to look at existing reservations and not be able
to reserve rooms.
The system should be a complete content management system for handling
the reservations of rooms, buildings, equipment and users. The interoperability
of the system should make it easy to access and use from dierent platforms.
