Phase 2
Michaelhouse
231094020121
,15 October 2023 231094020121
Contents
Design Document .................................................................................................................................... 4
Interface Design .................................................................................................................................. 4
Login Screen .................................................................................................................................... 4
........................................................................................................................................................ 4
Create Account Screen .................................................................................................................... 4
........................................................................................................................................................ 4
Main Menu...................................................................................................................................... 5
........................................................................................................................................................ 5
Student Menu ................................................................................................................................. 5
........................................................................................................................................................ 5
Add Student Screen......................................................................................................................... 6
........................................................................................................................................................ 6
Delete Student Screen .................................................................................................................... 6
........................................................................................................................................................ 6
Find Student Menu ......................................................................................................................... 7
........................................................................................................................................................ 7
Find Student by First Name Screen ................................................................................................. 7
........................................................................................................................................................ 7
Find Student by Surname Screen .................................................................................................... 8
........................................................................................................................................................ 8
Find Student by Grade Screen......................................................................................................... 8
........................................................................................................................................................ 8
Find Student by ID Screen ............................................................................................................... 9
........................................................................................................................................................ 9
Find Student by Dosage Screen....................................................................................................... 9
........................................................................................................................................................ 9
Medication Menu.......................................................................................................................... 10
...................................................................................................................................................... 10
Add Medication Screen ................................................................................................................. 10
...................................................................................................................................................... 10
Delete Medication Screen ............................................................................................................. 11
...................................................................................................................................................... 11
Assign Medication Screen ............................................................................................................. 11
...................................................................................................................................................... 11
FAQ Menu ..................................................................................................................................... 12
Page | 1
, 15 October 2023 231094020121
...................................................................................................................................................... 12
Change Password Screen .............................................................................................................. 12
...................................................................................................................................................... 12
Design Principles ........................................................................................................................... 12
Program Flow .................................................................................................................................... 13
Starting MediTrack ........................................................................................................................ 13
User Log In .................................................................................................................................... 13
Create Account .............................................................................................................................. 14
Add Student .................................................................................................................................. 14
Delete Student .............................................................................................................................. 14
Find Student by first name ............................................................................................................ 15
Find Student by surname .............................................................................................................. 15
Find Student by grade ................................................................................................................... 15
Find student by ID ......................................................................................................................... 15
Find student by dosage ................................................................................................................. 15
Add Medication ............................................................................................................................. 15
Delete Medication......................................................................................................................... 16
Assign Student to Medication ....................................................................................................... 16
Class Design and OOP Principles ....................................................................................................... 17
Method Descriptions......................................................................................................................... 19
Secondary Storage Design................................................................................................................. 20
tblStudents .................................................................................................................................... 21
tblMeds ......................................................................................................................................... 21
tblScripts ....................................................................................................................................... 22
tblUsers ......................................................................................................................................... 22
Explanation of database design ........................................................................................................ 23
Data Integrity & Relationships ...................................................................................................... 23
Scalability ...................................................................................................................................... 23
Complex Queries ........................................................................................................................... 23
Security ......................................................................................................................................... 23
Data Redundancy and Efficiency ................................................................................................... 23
Primary Data Structure related to Secondary Storage ...................................................................... 24
Student Class ................................................................................................................................. 24
Med Class ...................................................................................................................................... 24
User Class ...................................................................................................................................... 24
DBManager Class .......................................................................................................................... 24
Page | 2