TwinkleAgrawal CollegeManagementSystem

Download as pdf or txt
Download as pdf or txt
You are on page 1of 4

NATIONAL INSTITUTE OF TECHNOLOGY RAIPUR

---------------------------------------------------------------------------
TERM PROJECT
---------------------------------------------------------------------------

Submitted by: Twinkle Agrawal (19118091)


Subject: Database Management System
Subject Code: IT104103IT
Date of Submission: 18 April 2021
Submitted to: Tirath Prasad Sahu

Professor’s Sign:
COLLEGE MANAGEMENT SYSTEM (PYTHON+SQLite3)

ABSTRACT
This project is a GUI-based application program. Python is used as frontend
language and SQLite3 is used as the database backend language. The project is
mainly developed to provide ease to the college management authorities to
manage a vast information which is otherwise very difficult to manage. Now with
this there is no need for expensive software that will manage the college data.

NEED FOR THE APPLICATION


This application is useful in many ways. It keeps an account of the details of
students, students’ fee, students’ results, and books issued by student. This
program will be useful for both the students as well as the college authority as the
students can easily avail the required details and the college management can also
manage information very easily. Earlier all these procedures were done manually
which was very time consuming. This project would focus on increasing efficiency
and reducing time and cost.

FEATURES OF THE PROJECT


The project provides a menu of options like student profile, fee details,
library system in college and marksheet of students. The desired option
is chosen. On selecting student profile option, we can perform a
number of operations like save, reset, display, update, delete, search
and exit options. On selecting fee details option, we can perform a
number of operations like save, reset, display, update, delete, search,
receipt and exit options. On selecting library system option, we can
perform a number of operations like save, reset, display, update, delete,
search and exit options. On selecting marksheet option, we can perform
two operations search and create new. On selecting desired roll
number, the corresponding marksheet will be displayed if it exists,
otherwise we can create marksheet for the students.

ABOUT THE PROJECT


The database design strategy followed here is top-down design approach. The
first step was to identify the objects that we want to model and contain
information about. These objects are referred to as entity sets. In this project, the
entity sets used are student, fee, library, and marks. Then the next step is to think
about the attributes that will help in defining the entity sets. The attributes of
student entity are id of type integer, Name of type text which is a composite
attribute and consists of two attributes fname and mname, Address of type text,
mobno of type integer, email of type text, dob of type integer and gender of type
text. id is used as the primary key so it has property of both UNIQUE and NOT
NULL. The attributes of fee entity are id of type integer, recpt of type integer,
name of type text, admsn of type text, date of type integer, branch of type text,
sem of type text, total of type integer, paid of type integer, due of type ineger. The
attributes of marks entity are id of type integer which is the primary key having
property both unique and not null, name of type text, roll of type integer, fname
of type text, mname of type text, dob of type integer, gender of type text, email of
type text, cgpa of type integer, grade of type text and result of type text. The
attributes of library entity are refno of type integer, fname of type text, surname
of type text, address of type text, post of type integer, mobno of type integer, id of
type text, title of type text, author of type text. Database is created by using
MySQL connector. A database is created in sqlite3. In this database tables named
student, marks, library and fees are created using SQL commands. The Entity
Relationship Model will be used to show the entity sets, relationship between
entity sets, cardinality of relationship and degree of relationship. The relationship
between student and library is ‘issues_from’. The relationship between student
and fee is ‘pays’. The relationship between student and marks is ‘gets’.
This College Management System have a number of features. It includes menu,
student profile, library management system and marksheet. Talking approximately
the system, it includes all of the required features which consist of adding,
viewing, deleting, updating, searching and looking a student information lists
The frontend part includes python coding and Tkinter is imported for creating
graphical user interface. The backend part is written using sqlite3 which is a
standard database language.

FUTURE SCOPE
The project as of now includes the information related to student. But further the
project can be improved by adding information about teachers as well as other
staff members. More information about college events and cultural activities can
also be updated.

Entity Relationship Model

You might also like