Please enable JavaScript.
Coggle requires JavaScript to display documents.
St Joseph's Social Club Application - Coggle Diagram
St Joseph's Social Club Application
Client Problem
Client requires access to a superhero API that has been set
Client also requires significant data security
Application controls a significant piece of the school's login data for different students.
Client should be able to make comments on pieces of information
Client should have the ability to make posts based on games or interactive activities that occur in the social club.
Client should have the ability to create a login based on their personal information
Client also hopes to have several different permission-based clearance levels. (Teacher, Student President, Student etc.)
Client should also have a decent looking GUI that allows them to create an inclusive movie club allowing for the continued renewal of the school social club
Client also requires the ability to make an in-depth list of all the currently active members. There is also to be an automatically updating cell that allows for the changing of a student's status from active to inactive.
Developer Problem
Coding Problem
The data from the API should be scanned before it can be displayed to make sure that it solely relates to the Marvel Cinematic Universe rather than just being characters that in their time have been heroes in their own respect.
The data should be securely encrypted and decrypted to make sure that the security of both student, teacher and API data stays at highest priority.
Data should be encrypted and hashed during transport to make sure that it creates a secure undecipherable final message if it were to be intercepted.
An SQL database should be constructed with several tables interlinked by primary and foreign keys allowing for the succinct transfer and retrieval of data.
The data should be completely changed from XML or JSON to be reformatted into the SQL database and several tables.
Data Problem
There should be several tables normalised and linked via common primary keys such as unique IDs etc.
There is also the need to have a login table that is constantly updated and has several different spaces for uploads allowing for the editing and the creation of new and different login abilities.
Tables should be normalised to only include needed information
Graphical User Interface
This should be succinct in terms of number of buttons to be pressed by user.
This should use the school's colours in order to fully relate the database.
There should be the college crest to signify the relation as well
All pages should be delivered in an organised and aesthetically pleasing manor
The use of the TKInter Interface creation language and the coding software Visual Studio Code shall help tremendously with the creation of the GUI and the API's aesthetic design.
User Problem
Mr Rogers
Oversees the Social Club
Should be able to edit, create and remove content
Should also be able to see reviews and comments that have been made recently.
Taylor
Year 12 student that assists Mr Rogers
Should be able to edit and review while also having removal permissions like Mr Rogers.
Peter
Superhero Fan and Card Game Player
Is an active member of the social club
Chelsea
Marvel And Harry potter fan.
Likes giving feedback on the activities and posts.