Grade 12 IEB IT PAT – Phase 2 Only (Rowing Results System | 98%)

Information Technology
s




Practical Assessment
Task
Documentation
George Cox - Grade 12
2025

, PHASE 2
Design Document

Regatta Results
Developed by George Cox

, Table Of Contents

1. User Interface Design..........................................................................................5
1.1 Overview................................................................................................................. 5
1.2 Login Screen.......................................................................................................... 6
1.2.1 Component Breakdown.................................................................................6
1.2.2 Action Elements and Input Devices..............................................................7
1.3 Signup Screen........................................................................................................ 8
1.3.1 Component Breakdown.................................................................................8
1.3.2 Action Elements and Input Devices..............................................................9
1.4 Homepage Screen............................................................................................... 10
1.4.1 Component Breakdown.............................................................................. 10
1.4.2 Action Elements and Input Devices........................................................... 11
1.5 HomepageDashboard Screen.............................................................................11
1.5.1 Component Breakdown.............................................................................. 12
1.5. 2 Action Elements and Input Devices...........................................................13
1.6 Results Screen..................................................................................................... 14
1.6.1 Component Breakdown.............................................................................. 14
1.6.2 Action Elements and Input Devices........................................................... 15
1.7 Statistics Screen.................................................................................................. 16
1.7.1 Component Breakdown.............................................................................. 17
1.7. 2 Action Elements and Input Devices...........................................................18
1.8 News Screen........................................................................................................ 18
1.8.1 Component Breakdown.............................................................................. 19
1.8. 2 Action Elements and Input Devices...........................................................20
1.9 Admin screen....................................................................................................... 20
1.9.1 Component Breakdown.............................................................................. 21
2. Program Flow....................................................................................................22
2.1 Explanation...........................................................................................................22
2.2 Flow Diagram....................................................................................................... 24
3. Class Design and OOP Principles...................................................................... 25
3.1 Class Design........................................................................................................ 25
3.2 OOP Principles..................................................................................................... 26
3.2.1 Encapsulation.............................................................................................. 26
3.2.2 Abstraction.................................................................................................. 26

, 3.2.3 Inheritance................................................................................................... 26
4. Secondary Storage Design................................................................................ 27
4.1 Overview............................................................................................................... 27
4.2 tblUsers................................................................................................................ 27
4.3 tblTeams...............................................................................................................28
4.4 tblEntries.............................................................................................................. 29
4.5 tblEvents...............................................................................................................30
4.6 tblCompetitions................................................................................................... 31
4.7 tblCategory...........................................................................................................31
4.8 tblDemographic................................................................................................... 32
4.9 tblNews................................................................................................................ 32
4.10 Relationships..................................................................................................... 33
5. Explanation of Secondary Storage Design......................................................... 34
The Microsoft Access relational database was chosen for multiple
reasons:............................................................................................................34
Compared to text or JSON files:..................................................................... 34
6. Explanation of how Primary Data Structures relate to Secondary Storage..........35
Model classes..................................................................................................36
Manager classes............................................................................................. 36
7. Referencing...................................................................................................... 37