Teaching Days

From Apache OpenOffice Wiki
Revision as of 17:41, 29 June 2006 by DrewJensen (Talk | contribs)

Jump to: navigation, search

This is a small self containted (Currently) database used by substitute teachers, in my local counties school system, to keep track of how many miles they have traveled over the course of a year. It also keeps track of the total out of pocket expenses made in fulfilling their teaching assignments.

The database uses a very simple table structure, much more a flat database then a relational one.

TeachingDaysSchema 1.png

Currently the database is intended to only track assignments where the teacher is sent to one school during any one day.

The database is setup to use the two entries, FirstSchoolDay and LastSchoolDay, in the config table as lower and upper bounds for all queries. This limits queries to a time period representing the current school year.

One item of interest in the database is the use of the data type VARCHAR_IGNORECASE. This is datatype is unique ( or almost ) to HSQL. The datatype was used explicitly to take advantage of a combobox on the main input form.

Workday form 1.png

The form uses three drop down lists. Two are list boxes, both display data that is not expected to change often, if at all during a school year. The combo box highlighted in the screen shot on the other hand is used to selected from a list that is expected to continue to change often as the year progresses.

Personal tools