ECommerce Technical Issues
Assignment 3
2000

Overview

XMl is likely to be used as the standard data interchange format for most business data. XML is not a presentation format, unlike HTML or WML. This assignment is to allow queries to be made of a database, and the information will be returned in XML format. If desired, this may be converted to HTML or to WML.

Details

Employee information is stored in an SQL database such as mySql. This includes name (first and last, as separate fields), address (including street and suburb as separate fields) and job position. Queries can be made on this database to return all matching records for any one of the fields. For example

• Find all people with surname "Smith"
• Find all people with job position "Clerk"

You need to make three interfaces to this database

• Any query should return the results as an XML document
• A query result may be rendered from XML to HTML for display in a table
• A query result may be rendered from XML to WML for display with each person's details on a single card

It may be simplest to have 3 URL's, one for each type of result format. Each one should use the XML format as intermediate format.

Due date

This assignment may be done in groups of no more than 3 people. It is due on Nov 14