Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL Robotics Database - Coggle Diagram
SQL Robotics Database
Python
Interface
Using the PyFiglet module to create introduction text, something like - "Welcome To Robotics Database Searcher" - with a nice font.
There will be numbered options for what to search, there will also be an option where if the user knows SQL, they can input direct commands.
When the user selects an option it will provide the user with instructions on how it works and will then take the users input and turn it into an SQL statement
Will use well contrasting colours for the instructions, welcome, text, and the options
A box surroundings key elements, such as the input sections and the insturctions, and the list of options
Features
The interface will allow the user to search various pre-made functions, these may include searching a specific student name, searching a specific team name, or the result for a specific competition
Will also allow the user to perform custom searches where they input every variable that they want to search and the computer will take this information and convert it into a search, this can be done without the user knowing anything about SQL
If enough time, I want to add a feature that let's the user add records to certain tables on the database
IF even more time, there should be a feature that lets the user update pre-existing records of the database, and potentially add their own tables. They would also be able to delete records in the database, it will be fully interactable without the user knowing anything about sql
Tools
-
-
The time module will be used so that there can be time between printed lines of the database and so that there is time bewteen the inputs created.
-
SQL
Entities
Students Table: A Student_ID field as the Primary Key, and different fields for all the other information that has beeen given in the task.
Competitions Table: This table will use a "Competition_ID" for the primary key, and will contian fields for the other information
Teams Table: This table will contain info for teams and will have a relationship to the student table, the student table will read the team_id from this table
Results Table: The main table that links to all the other table, it contains info on students, the competitions that they competed in, and the teams that they are a part of, it is the main relational table
-
-
-
-
-