Enhancing Student Information Management through a Database-Driven Approach

This project aims to create a file folder structure for performing CRUD (Create, Read, Update, Delete) operations in Python using SQLite3 database. The structure includes five files: main.py which handles the graphical user interface and acts as the driver for the whole application, and four other files create.py, read.py, update.py, and delete.py that perform the CRUD operations on the database. All these files are stored in a folder called database, which also includes the SQLite3 database file database.db. In each of the four files, create.py, read.py, update.py, and delete.py, there are separate functions for performing the corresponding CRUD operation. These functions connect to the SQLite3 database, execute the required SQL queries and then close the database connection. In main.py, these functions can be called to perform CRUD operations and display the results in the GUI. This file folder structure is scalable and can be adapted for use in various projects that require CRUD operations in Python with SQLite3 database