Hi, I’ve offered to make a web based studio booking system for the
university I attended to replace their old pen and paper approach and
I’m having some trouble deciding on the best way to organise the
What will happen is the students (or tutors) will log in and be
presented with a weekly calendar view of the studios, along with details
of existing bookings. They can then enter details of when they want to
book and which studio they will be using etc…
Each student has a certain amount of hours available for studio use per
module code. For example they may be allowed 100 hours for a recording
module using the code ‘REC’ and 150 hours for extra curricular study
using the code ‘EXTRA’. They will not be able to exceed this limit. Any
time booked using the ‘EXTRA’ code can be overbooked by other students
using a module code such as ‘REC’.
There are three years of study on the course. The second and third years
have unrestricted access to the studios but the first year students are
only allowed in certain studios.
So I figure that the details I will have to store in the database are:
Year of study
Which module/extra-time codes are available for use
Amount of hours used per code
Details of existing bookings
Which studios are available for use to each year
Total mount of hours allowed per code
Module/extra-time code precedence
What would be the best way to organise all of this information in a
database? I would really appreciate any help you can give to me as I’m
still quite new to programming and could really do with some experienced
advice. I can provide more details if needed.
Thanks in advance!