BIHE, Bolton Institute of Higher Education (University of Bolton – 2004)
(University status attained in April 2004)
Website: http://www.bolton.ac.uk
Year: 1988 – 1990
Course: BTEC Higher National Diploma in Computer Studies
Awarded: DISTINCTION (overall first over the 2 years)
Operating SystemLanguages / Other
PASCAL, DBASE3, MS-DOS, SQL, COBOL74, ORACLE, FMS
The HND course I attended at BIHE was a 2-year, full-time course made up of the following modules:
- Computer Systems Architecture
- Programming Methodology Theory / Practice (final year project)
- Data Processing
- Business Studies
- Quantitative Techniques
- System Analysis
- Business Information Systems Theory / Practice
My final year project consisted of an ORACLE SQL-forms designed GUI interface running under an MS-DOS operating system. The GUI interface provided 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. System analysis work was carried out using SSADM (Structured Systems Analysis and Design Methodology).
