DBMS Mini Project - Group No. 21 | Student Information Management System (SIMS) | With Source Code

Title of the Project: Student Information Management System (SIMS)

Abstract:
Implement MySQL / Oracle Database connectivity with PHP / Python / Java.
Implement Database navigation operations (Add. Delete, Edit) using ODBC / JDBC.

Introduction:
A Student Information Management System has been implemented using Python Programming along with MySQL Database Connectivity on Visual Studio Code (VSC).
The purpose of this Mini-Project is to implement the CRUD (Create, Read, Update, Delete) operations related to database on a Real-Time example.
Initially, MySQL was connected with Python using PyMySQL Library.
A database was created with appropriate attributed for the same. The prime operations to be done are:
1. Inserting new Student Information in the table.
2. Displaying the Student Information.
3. Update Student Information.
4. Delete Student Information

Scope:
This project provides a great help to teachers in managing the data of students in a well-mannered order. This project is designed specially to maintain Student Information like (ID, Name, Branch, Roll No., Gender).

Requirements: (Used while making this Mini Project)
• 64-bit OS (macOS Catalina v10.15.7)
• Python3 v3.8.6
• Pip3 v20.3.3
• MySQL v8.0.22
• PyMySQL Library (v1.0.2)
• Visual Studio Code (VSC) v1.52.1