To migrate a CODASYL legacy database system to a JAVA database application, using
JDBC and ORACLE.
The legacy system is the Course Administration System used by the Continuing
Education department.
This project will be divided into a number of sections:
- Analyse the current system, and look at ways to improve the
functionality
- Analyse the codasyl model and produce an accurate relational model.
- Analyse the relational model, to determine the kinds of integrity
constraints that should exist.
- Design and implement the schema in Oracle on Solaris.
- Design, implement and document a new version of the CAS system using
Visual Age (IBM) for Java, Visual J++ (Microsoft) or JBuilder (Borland)
- Port this Java application to Solaris and test using the Sun Java station.
This project is large enough to support 3 MSc students working on different
parts of the system.
The primary aim of this project is to look at what kinds of integrity constraints
exist in legacy systems, and to determine what integrity constraints should exist.
This project will build on work carried out by Nic Caine as part of Ph.D.
research. There are various modules that may be of relevance in the project,
and the candidate will be encouraged to consider multiple modules. There is scope for publication of
this work, and possible inclusion in a future research report.
If students are serious about undertaking this project, then please contact Nic
Caine scmnjc@cs for further information about the project.