Please enable JavaScript.
Coggle requires JavaScript to display documents.
Developing a "School Database Management System" - Coggle Diagram
Developing a "School Database Management System"
The developer Problem
Backend Code
Link main file to UI files
UI Files
UI files created in QTDesigner
SQL Queries
SQL queries to sort, add and update data
PyQt5 Code
Link UI files to main window and link user input to a data process
Database File
Data Integrity
Link Database file to Main Window and Code
Data is stored correctly within tables
Login
Search through users file username and password in order to login
Coded Components
Libraries
SQLite3
PyQt5
Classes
OOP
while loops
CSV reader
User Defined Functions
Variables
Passing values
SQL Code
Executable Code
User Interface
Buttons
Table
Line Edits
Tickboxes
Comboboxes
Spacers
The User Problem
Useability Principles
Portability
Plateform Independent
Responsiveness
Fast
Efficient
Bug/Error Free
Learnability
Easy to use and develop skills for
Accessibility
Help Guide
Colour Blind Mode
Utility
Able to log whole school information and data
Meet all requirements
Enter Data
PC Groups
Year
Semesters
Subjects
User Details
Staff able to enter student Results
View Data
Find results for a particular student
Find all results of a PC Group in order of lastname
Find all D and E results in a given year with names
User Experience
Good user feedback
Fast
Simple
Efficent
Only allow access to Staff and Administrators