Student Database Management System

About the Project

The Student Database Management System is a comprehensive solution designed to efficiently manage student information using SQLite3. This project simplifies the task of storing, retrieving, and manipulating student records, offering a user-friendly interface for administrators or educators. Developed with SQLite3, Python, and various libraries, this system ensures reliability and ease of use in managing student data.

Purpose

The purpose of the Student Database Management System project is to provide a practical learning experience in database management, Python programming, and the utilization of various libraries. By building this system, users gain hands-on experience in effectively managing student data, understanding SQLite3 database operations, and implementing user-friendly interfaces using libraries such as questionary, matplotlib, pandas, and rich. This project serves as a valuable educational tool for students to deepen their understanding of database management systems and enhance their programming skills.

This project was undertaken as a school project to apply theoretical knowledge into practical implementation, emphasizing the importance of database management in educational settings and providing a platform for educators and administrators to efficiently manage student records.

Preview

Preview.mp4

Setting Up Locally

Prerequisites

Make sure you have Python installed on your system.

• Python: Download and install Python.

Installation Steps

1. Clone the repository

   git clone https://github.com/AverageBlank/StudentDatabase.git
   cd StudentDatabase

2. Create a virtual environment (Optional)

   python -m venv venv
   source venv/Scripts/activate  # On windows use `venv\bin\activate`

3. Install the required libraries

   pip install -r requirements.txt

4. Run the application

   python main.py

Languages Used

• Python: The main programming language used for the backend.
• SQL: Language used for interacting with the SQLite3 database.

Libraries Used

• math: Provides mathematical functions.
• os: Allows interaction with the operating system.
• string: Implements common string operations.
• time: Provides various time-related functions.
• questionary: A Python library for building interactive command-line applications.
• matplotlib: A plotting library for the Python programming language.
• pandas: A fast, powerful, and flexible open-source data analysis and manipulation library.
• rich: A Python library for rich text and beautiful formatting in the terminal.
• sys: Provides access to some variables used or maintained by the Python interpreter and to functions that interact strongly with the interpreter.
• sqlite3: A built-in Python library for interacting with SQLite databases.
• cryptography (fernet): A cryptography library for secure communications. Fernet is used for encryption and decryption.