I have designed a dB (access2002) which is for a booking system for a college. i have recorded in seperate tables
STUDENTID, student forename, student surname, Classid
ROOMNO, max students, computers(Y/N)
block caps are PK's
The table to book is
I have to be able to record individual student hrs/tutor hrs room hrs students by class etc and show which students are in which room at what time
the database does this but is there a better way..?
Also think have got normalisation but how can i normalise room booking table...do i have to split table into date..time and the redefine relationships