St Joseph's Social Club Application

Client Problem

Developer Problem

User Problem

Coding Problem

Mr Rogers

Taylor

Peter

Chelsea

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.

Superhero Fan and Card Game Player

Is an active member of the social club

Year 12 student that assists Mr Rogers

Should be able to edit and review while also having removal permissions like Mr Rogers.

Marvel And Harry potter fan.

Likes giving feedback on the activities and posts.

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.

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.

Data Problem

There should be several tables normalised and linked via common primary keys such as unique IDs etc.

The data should be completely changed from XML or JSON to be reformatted into the SQL database and several tables.

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.