June 2010
Schedule Hacking Part Three: Design Adjustments and Networking
After designing the new entry forms, I went to work updating the other database forms. Most of it was minor adjustments, like changing the entry form for the old Professor table to new Contact table. A bigger change was the staff assignment form. While it was possible to assign staff to a setup or a pickup when the class was entered into the schedule, it wasn’t always possible to know who would be available. Also, staffing changes over time and someone scheduled to handle a class for a whole semester may be out for a day or more during that semester. The assign setups form showed all of the setups and pickups scheduled for a specific day and allowed the staff assigned to each to be set or changed.