Bolton Institute of Higher Education, 1988 – 1990
BIHE before 2003My final year project consisted of an ORACLE SQL-forms designed GUI interface running under an MS-DOS operating system. The GUI interface provided traditional insert, update, delete and transaction rollback facilities for recording information about students attending courses at BIHE, along with their module assignment and exam result details. The student data was held in an ORACLE SQL database set-up on a PC local to the application.
The tables were designed in accordance with Third Normal Form (TNF) design methodology in order to cancel out repeating student data. The resulting application catered for both snapshot and historical reports. Systems analysis work was carried out using SSADM (Structured Systems Analysis and Design Methodology).