Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Model - Coggle Diagram
Data Model
Events Table
Event ID
Event Name
Date of event
event type
Organisers
Number of event student atendees
number of points earned at this event
House with the most points earned that this event
Student table
Student ID
Student Name
Student EMail
Tutor group
House
Number of points
Number of unique events attended
House Table
House ID
House name
Number of Supporters
Number of Points
House contact email
Organisation Table
Organiser ID
Organiser name
Organiser Email
Number of unique events attended by the organiser
Admin Table
Admin table
Admin Name
Admin Email
Data Environment
Need to store user registration data
Need to protect personal information due to privacy act
Password system to restrict access
2 Factor authentication to provide extra security
Need to update information in the table
ID, Name, Year, Tutor Group, House, Email
Central Database
All information is already in Userbase
Only need to add password
Need to send Email to their school email