SCHEDULING INFORMATION SYSTEM: THE DESIGN AND DEVELOPMENT OF AN ONLINE DATABASE FOR TRACKING SCHEDULING INFORMATION

by Li, An

This paper describes the design and development of a Web-based scheduling information system. This particular system is intended to allow workers to enter the hours they would like to request to work so that the scheduler can query the database to see who is available to work on which days in order to make the schedule. The workers are able to query the database as well, so that they can see how many other people have requested the days they plan to request for.

For data input, the proposed system presents Web-based HTML forms that can be accessed from any Web browser; the system stores the collected information in a MySQL database. PHP scripting language is used to link the HTML forms and the MySQL database; it constructs SQL insert statements to enter data into the database, and constructs queries to extract information from the database.