This is project of our sophomore project of Data Base Management System made using Python and Sqlite.
In this student database management system we can add, delete,update,view and clear existing records from the database.
Here Student ID acts as the PRIMARY KEY and we store Student name,age,gender,address and mobile number.
Here are some of the screenshots of the frontend:
Here Add new- Adds new informtion related to student.
Clear- clears the entry box for new entries.
Search- Enter any keyword in the query box and search will show you the relevant results.
Update- Updates any changes applied to that particular given user.
Delete- Deletes the entire dataset selected.
Display- Views the entries till date.
Here is how the Exit button works:
If we press 'Yes' it will exit the process and if we press 'No' it will return to process.
This project was undertaken under the guidance of Dr. Brij Bihari Dubey of the Database Management Systems.
Language used: Python 3
Query Language used: Sqlite 3
Library:Tkinter
Other concepts involved: Object Oriented Programming(OOPS)