Develop PHP-MySQL Systems

Background

We have three database systems that need work
  1. Handwriting forgery quiz system
  2. DPS dissertation database system
  3. Genealogy database system
We are primarily interested in the first system, but if time permits minor work can be performed on the other two.

Handwriting Forgery Quiz System

This system currently uses ASP to connect to a Microsoft Access database of handwriting samples. Because ASP is not supported by the Pace University server systems, we want to convert this system into PHP accessing a MySQL backend database.

All files related to this system will be provided.

Doctor of Professional Studies (DPS) Dissertation Database

The Doctor of Professional Studies (DPS) in Computing at Pace University is a a unique doctoral program that allows active IT professionals to earn a doctorate degree in three years through part-time study. There are currently about 70 completed DPS dissertations, see DPS dissertations (pw=digitalthesis).

The DPS dissertation database categorizes dissertations in a number of ways and collects associated information in one location. Each dissertation is given

A MySQL database with a PHP web interface was completed recently, see the interface at DPS Dissertation Database (currently not working) Access to the server directory containing the database will be provided. The associated Research Day 2012 paper describes the system.

The project this semester will develop and modify the tables and queries.

Genealogy Database

If time permits we will examine for possible extensions the Genealogy system, see Genealogy Database Manual. Access to the server directory containing the database will be provided.