hello.. i'm looking for tips in my database (using wamp server) in Room Scheduling System
Basically the input is a Class Schedule..
ex.
math1 8-9am monday
eng1 9-10am monday
computer1 8-9am tuesday
up to 8+ subjects.. for the whole week (monday - saturday)
after the input.. the system will automatically plot the class schedule in each possible rooms available. with no time/room conflicts with other schedule/subject.. rooms have room type and subjects have subject type.. rooms can only be used if room type = subject type.. if the subject inputed has no available rooms at all.. the system will put that subject in a somewhat 'special area/unscheduled area'.. something like that.. still the whole class schedule is accepted..
i need some help with the database.. i'm struggling thinking how to eliminate time conflicts in every room and in every day..
hope you can help me..