Technology stack:

MySQL database -- http://www.mysql.com
Apache Tomcat Server -- http://jakarta.apache.org

Oracle XSQL Pages  -- http://otn.oracle.com/docs/tech/xml/xdk_java/doc_library/Production9i/java/xsql/readme.html
XSLT -- http://www.w3.org/TR/xslt
Perl -- only involved in the first part of the project

Overview:

The project will be using a MySQL database to hold the BASICS data.  The data from this database will be published to the web using an XML-based publishing framework known as XSQL.  The XSQL pages query the database using SQL statements and automatically produce output that is in an XML format.  The XML format is then translated into HTML form through XSLT.

Major categories of work:

• Translation of legacy Perl code into XSQL+XSLT.
• Designing the database -- mainly table structures and relationships between tables.
• Reports -- XSQL pages for querying and retrieving information from the database.
• Forms -- XSQL pages for specifying information to be stored in the database.
• HTML and graphic design -- web site flow and visual aesthetics.
• Architectural review -- using some higher-level object-oriented principals to keep the code base maintainable.