Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database - Coggle Diagram
Database
Fuctional requirements
The data must be connected and made easy to interpret.
It must have a python interface
It must use pycharm to develop the interface.
Must be a simple python database
Must be able to interact with the data stored quickly
Solution must be a prototype only
Must be a simple working version that can be built upon in the future.
Must be user friendly
The database must include the current team competing in the competitions
Must be a python database prototype
Must use SQLite to make database
The database must be made to suit the needs of Mr Dahms
Must be able to search database
The database has to store student information, incudes
First Name
Last Name
Date of Birth
Nudgee email address
Nudgee house
Team
The database has to store competition information, includes
Competition name
Center
Time
Status
The must be results recorded from all the competitions this must include
students involved
competition name
place that was rewarded
Time participated in completion
python
Interface
Simple
User friendly
Suits the needs of Mr Dahlms
Tools
Maths
if statements
Varibles
Functions
Features
Have a simple interface
Be able to interact
Perform Searches
Imports
time
art
turtle
pyfiglet
User
Mr Dalhms
Other teachers
Head a faculty
Constraints
Capabilities of the technology
The wants of Mr Dahlms
Time
Developing tools
Pycharn
Visual Code studio
SQLite
Relationships
1:M - Many student can only have one team
1:M - One team can only have many results
1:M - One competition can have many results.
SQLite
Entities
Competition
comp id
PK
name
location
time
startus
Result
result id
PK
team id
FK
comp id
FK
place
FK
time
Students
student id
PK
first Name
last Name
DOB
email
house
team id
FK
team
team id
PK
team name
Tables
Result
Competition
Students
Team