1. [50] Basic functionality: your application must support basic database operations such as looking-up, inserting, deleting, and updating. All these must be implemented in your application program and interact with the database through ODBC or JDBC.

2. [20] Web based: users can access your database on line from a web browser. You can implement it using MS ASP (or Java servlets, PHP, etc.).

3. [20] Error checking: your application should be robust enough against bad inputs. For example, a ssn must be exactly 9 digits etc. Is the checking done by application or by database? Explain the trade-offs and give examples of by both.

4. [10] Referential integrity constraint:  let the user see the available input values at runtime (e.g. an existing ssn) during insertion and cascade deletes.

Submitting instruction: submit an electric copy of all your files in compressed form to lfu@uncg.edu. They include your code files, html files, and a "readme" file. In the "readme" file, you may include author (it's you!), date,  a brief description of your application, a list of all the files with their brief descriptions, and instruction of how to run, etc.

If you have any questions, feel free to contact me.