A Web-Enabled Aircraft Scheduler

1
A Web-Enabled Aircraft Scheduler
Michael Wallette 20 Nov. 2002
2
Project Description
Web-enabled, database driven aircraft scheduling
application using the following components

• MySQL v. 3.23.49 database.
• Apache v. 1.3.20 web server.
• Perl v.5.6.1 Scripts.
• Slackware Linux 8.0 Operating System.

3
Project Requirements

• On-line schedule with 24x7 access.
• Automated process with minimal staff intervention
  required.
• Fully integrated web package
• Club information
• Aircraft description
• Membership application
• Flight Instructor contact information
• User administration functionality for club staff.
• Inexpensive to build and maintain.

4
Database Design
5
Perl and HTML code
18 HTML documents and 12 Perl scripts. Perl
scripts generate HTML code for dynamic pages,
like the following
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
Site Navigation for Main Program
Note--Static HTML pages that do not call or
respond to CGI scripts have been ommitted.
11
Site Navigation for Administrative Tools
12
Conclusion

• What went well in version 1.0
• Perl/Apache/MySQL integration.
• Most user interfaces.
• Database design.
• What to look for in version 2.0
• New schedule interface.
• Cleaner, more optimal Perl code.
• Pages optimized for typical resolutions
  (currently, designed for 800x600, with
  compromises for other resolutions).
• Enhanced security.

13
(No Transcript)