classroom scheduling

[Iconoclast]

Can anyone please help me...
I'm trying to formulate a database wherein there are three primary tables.
The first table, SUBJECTS, contains subjects (courses), its durations, its
capacity, needed equipment, meeting time/days - M/W T/F or Th/Sat, etc. The
second table , ROOMS, contain the number of available rooms, its available
time, its facility/equipment, and its capacity. The third table, FACULTY,
includes instructors, their preferred subjects, and their available time.

My problem here is how to find a simpler/automated way of assigning the
Faculty to Subjects then Subjects to Rooms without causing conflicts in the
schedule such as overlapping subjects in a single room, or faculty assigned
to teach two subjects at the same time.

What I have so far is a system which is done visually, i.e., Each subject,
room, faculty are encoded then each subject is assigned to rooms which meets
the capacity and is still vacant. It is very tedious and time-consuming.

 

[Mike Painter]

Can anyone please help me...
I'm trying to formulate a database wherein there are three primary
tables. The first table, SUBJECTS, contains subjects (courses), its
durations, its capacity, needed equipment, meeting time/days - M/W
T/F or Th/Sat, etc. The second table , ROOMS, contain the number of
available rooms, its available time, its facility/equipment, and its
capacity. The third table, FACULTY, includes instructors, their
preferred subjects, and their available time.

My problem here is how to find a simpler/automated way of assigning
the Faculty to Subjects then Subjects to Rooms without causing
conflicts in the schedule such as overlapping subjects in a single
room, or faculty assigned to teach two subjects at the same time.

What I have so far is a system which is done visually, i.e., Each
subject, room, faculty are encoded then each subject is assigned to
rooms which meets the capacity and is still vacant. It is very
tedious and time-consuming.

There is no simple way.
It will require a lot of code, a lot of time and probably will have to be
massaged by hand anyway.

You have missed an important part of the conflicts since, especially in the
upper grades, students who need two classes taught at the same time may need
both classes to graduate.

This is also something that cries out for features lacking in Access, such
as drag and drop or a really powerful grid control.
Actually the drag and drop should swap the location of the "drug to"
location with the "drug from" location.