Please enable JavaScript.
Coggle requires JavaScript to display documents.
FIA2 Terrace Support System - Coggle Diagram
FIA2 Terrace Support System
Data
MySql
Will be connected to MeekroDB; MeekroDB is how the php file will communicate with the database,
Tables
Attendance: This table lists the different events and who's attended them. Also lists which houses the users are in to simplify the leaderboard process. Contains foreign keys from the users and events table.
Events: Event name, location, the date and time, etc... Details will vary according to the event that the administrator adds.
Users: id, first name, last name, etc... Excluding the password, all info involving the student derives from the user base. This table would vary depending on which component is being discussed (Organiser or Administrator).
MeekroDB
Limitations, Boundaries
Whilst the implementation of a teacher registration component would provide more depth to the system, it would cause further confusion to both myself and the users. In addition, it would put further pressure on completing the system prior to the time constraint.
Coding/Programming
SQL
HTML
PHP
User Interface
Leaderboard Page: At the very least should list the houses and the total points earned by each house. If extra time would like to implement a student leaderboard and perhaps leaderboards unique to each house and tutorgroups
Events Page: Would provide all the details of the events. Would be accessible by pressing the link of each event present in the users page. Use should be able to see details of upcoming events and events already attended. Information should already be present within event table so should not be difficult to implement.
Profile Page: Provides the details of the user as well as points earned. This information would be saved to the users table during the registration process, meaning printing this information is once again just a simple mysql query.
User Page: would provide a view of all the events attended by the student as well as points earned and upcoming events. All information should already be present with in the databases meaning the implementation should just be a simple mysql query.
Styling/Themes/Aesthetics
Colours: Red, black, white
Should be terrace themed whilst being simple and easy on the eye.
The overall look of the ui should be simple and relatively basic, with only providing necessary information to the user in order to prevent confusion. With the idea of multiple age groups using the system in mind, it is important it can be easily followed and appeal to a younger demographic.