Please enable JavaScript.
Coggle requires JavaScript to display documents.
ITrain - Coggle Diagram
ITrain
Functional Requirements
Devices
Bootstrap 4
SQL run in Xammp, with datbases
website created with php, css, html, maybe a bit java
SQL / Data
team
team_id, team_name, team_grade, team_sport
event
event_id, event_sport, datetime
players
participation_id, role, user_id, team_id
attendance
attendance_id, event_id, user_id
users
user_id, scode, fname, sname, grade, house, email, password, permission
Idiot protection
Students can not attend multiple times for one event. Including on other devices.
Students must be logged in to attend a game.
Organizers will be able to see which students have attended and remove those who pretend that they did
Enable Safety measures / Sanitisation
Stripslashes, trim, htmlspecialchars... + using Post and php.
Non-functional Requirements
User perspectives. (Sign up, and Log in are assumed)
organisers
Attend a game / training
View their teams attendances
admins
create teams + add specific players inside team
Remove Teams + remove specific players inside team
Create an event + its date and time
View students and organisers attendances.
student
Attend a game / training