This is a Relational Database project for a student records system. It develops a program to manage student records, including adding new students, updating grades, and generating reports.
The database is based on MySQL, and all the functions of the program were written in python. With mysql.connector to connect with the database which was created in MySQL workbench.
The database was called 'studentrecord', which contiens major,studentcontactinfo, studentgrade and studentname tables. All the tables use student id as the primary key to search and look up rows.
It was a great practice to use/create a database and use Python to write functions for the database.
-Vitual Studio Code -Python 3.11.7 -MySQL Workbench
Lanuage: -Python: For the function -SQL: for creating database
Library: -mysql.connector: Built connetion between Python and SQL
{Make a list of things that you need to fix, improve, and add in the future.}
- Generate a report for a major
- Improve user interface