Checking if Date/Time is Available (and then some more)

Okay, so I am stepping out of my as3 skill set here quite a ways and need some bookoo assistance (Flash 5.5). I am working on trying to come up with a way (an AIR desktop application, or web application) for the teachers on my campus to be able to assign students to a variety of detention types, dates/times with limited seating available.  I want the teachers to be able to input the student data and select a date/time or even multiple dates/times, then have the program check to see if there are any available seats remaining for that date/time.  If so, assign the student to that seat.  If not, display the next available seat's date for that time slot with the option to assign student to that date or choose another.

I also want to be able to run a report that will tell me who is serving which detention, when (date/time) and in what room.

I would also like teachers to be able to "re-assign" a student if they needed to for whatever reason, thus freeing a seat in the previous slot and filling a seat in another.

I'm not quite sure where to start aside from the interface design (that I can easily handle). Does anyone know of a good tutorial (or a few) that could get me on my way to try to code all this?

Thanks!