Please enable JavaScript.
Coggle requires JavaScript to display documents.
Mr Dahms Robotics Club Database - Coggle Diagram
Mr Dahms Robotics Club Database
Tools
Visual Code Studio
SQL
SELECT
UPDATE
DELETE
INSERT
CREATE
ALTER
DROP
INNER JOIN
Python
Functions
to help output tasks
Loops
to iterate over an object until it's complete
Variables
to store informaton
importing external libraries.
to help connect SQL to the python file.
Security
I can install a python module using pip, called safety and it will instantly check the python vulnerabilty database fro any threats.
Always use the latest version of python
use a virtual environemnt when installing new packages.
never commit anything with a password or API key in it
SQLlite
A great program to make databases
User
Teachers
Keep track of student's data
Has to have access to student database to add or remove student
Competition organisor
Needs to manage submissions
Needs to manage student competitions
Needs to manage students data
User does not know any SQL
There is an interactive menu to communicate with the database
The database has to be accessed with ease
The user does not have to knmow any SQL, that is the beauty of the project.
Success Criteria
Non-Functional Requirements
Colourful
Teachers have to find it easy to use
Functional Requirements
Program to keep track of users data.
So Mr Dahms can keep track on who is still enrolled and who is absent
The program has to efficiently store data.
to ensure that no student is left out or no competition is missed.
interactive database
Relational Database
programmed with Python & SQL
The database was coded in SQL to store students data, competitions data and results data
Python is used to create the interactive database to visually make sense of the database.
The interface has to be simple to use
Content
Student
First Name
Last Name
House
Email
Team
Age
Competitions
Name
Suburb
Location
Date
Results
Result