Download Comp 4 Documentation - 1337 Upload`s file server

Transcript
COMP4 – Physics Quiz Generator
Contents
Analysis ................................................................................................................................. 4
Project Problem Definition ................................................................................................. 4
Background to the Problem ................................................................................................ 4
Interview with Anne Lancaster - The Primary Client .......................................................... 5
Observation of Existing System .......................................................................................... 7
System Flowchart .............................................................................................................. 10
Prospective Users and Acceptable Limitations ................................................................. 11
Document Specification Sheets - Volumetrics and Data Dictionaries .............................. 11
Data Sources and Destinations ......................................................................................... 23
Data Flow Diagrams .......................................................................................................... 24
Entity Relationship Diagram ............................................................................................. 26
Tasks to be Computerised and the Benefits of Computerising ........................................ 27
Objectives for the Proposed System................................................................................. 28
Potential Solutions and Justification of Chosen Solution ................................................. 29
Design ................................................................................................................................. 32
IOPS Chart ......................................................................................................................... 32
System Flowchart .............................................................................................................. 32
Data Flow Diagram ............................................................................................................ 34
Data Dictionary and Validation ......................................................................................... 35
Justification of Included Question types........................................................................... 37
Stepwise Refinement ........................................................................................................ 38
Database Normalisation and Design................................................................................. 39
Table Relationship Diagram .................................................................................. 42
Sample of Possible SQL Queries............................................................................ 43
Top-Down Design .............................................................................................................. 44
OOP Class Design .............................................................................................................. 45
Definition of Record Structure .......................................................................................... 46
Security and Integrity of Data ........................................................................................... 46
User Interface Design ........................................................................................................ 47
Form Navigation Design .................................................................................................... 55
Damask Talary-Brown - 5556
1
Centre Number 64395