SPRING MEADOW2S PUBLIC

SCHOOL
2022-23

Computer Science Project

On
University Management
System
XII C
UNDER THE ESTEEMED GUIDANCE
OF
MR. Vijay Rajput, C.S. FACULTY

BY
Ankit Kumar – 16
Arsalan Ali – 17
Nihal Kumar - 24

1|Page
This is to certify that the content of this project entitled,
“UNIVERSITY MANAGEMENT SYSTEM” by the
group of students including- Arsalan Ali, Ankit Kumar,
Nihal Kumar is the bona fide work of us submitted to
Spring Meadows Public School for consideration in
partial fulfilment of the requirement of CBSE, Delhi for
the award of Senior School Certificate in Computer
Science.

The original research work is carried out by us under

my supervision in the academic year 2022-23. On the
basis of the declaration made by us we recommend this
project report for evaluation.

Certified By:
Vijay Rajput sir

2|Page
 While we were preparing this project file, various information
that we found helped us in chapters like My SQL , Python ,
Data handling etc. and we are glad that we were be able to
complete this project and understand many things. Through
preparation of this computer science project was an immense
learning experience and we inculcated many personal qualities
during this process like responsibility, punctuality, confidence
and others.

we would like to thank to our teacher who supported us all the

time, cleared our doubts and to our parents who also played a
big role in finalization of my project file. We are taking this
opportunity to acknowledge their support and we wish that
they keep supporting us like this in the future.

A project is a bridge between theoretical and practical learning

and with this thinking we worked on the project and made it
successful due to timely support and efforts of all who helped
us.

Once again, we would like to thank our classmates and our

friends also for their encouragement and help in designing and
making my project creative. We are in debt of all these. Only
because of them we were able to create our project and make it
good and enjoyable experience.

3|Page
S.NO Contents PG.
. NO.
1. Introduction
 ABOUT PROJECT

 PURPOSE

 PROJECT SCOPE

2. OBJECTIVE:
 PROJECT OBJECTIVE

 PROJECT CATEGORY

3. ABOUT:
 MySQL CONNECTOR

 MySQL

 PYTHON

4. DATA STRUCTURE (LIST OF TABELS)

5. LIST OF MODULES USED

6. TOOLS , H/W & S/W SPECIFICATIONS

7. D.F.D. DIAGRAM

4|Page
8. ER DIAGRAM

9. BIBLIOGRAPHY &
REFERENCES

5|Page
 INTRODUCTION
 ABOUT THE PROJECT
The "Hospital Management System" has been developed to override
the problems prevailing in the practicing manual system. This soft
ware is supported to eliminate and in some cases reduce the hard
ships faced by this existing system. Moreover this system is designed
for the particular need of the company to carry out operations in a
smooth and effective manner. The application is reduced as much as
possible to avoid errors while entering the data. It also provides error
message while entering invalid data. No formal knowledge is needed
for the user to use this system. Thus by this all it proves it is user
friendly. Hospital Management System, as described above, can lead
to error free, secure, reliable and fast management system. It can
assist the user to concentrate on their other activities rather to
concentrate on the record keeping. Thus it will help organization in
better utilization of resources. Every organization, whether big or
small, has challenges to overcome and managing the information of
Collage, Students, Classes, Courcer, Faculties, Semester. This is
designed to assist in strategic planning, and will help you ensure that
your organization is equipped with the right level of information and
details for your future goals. These systems will ultimately allow you
to better manage resources.

6|Page
  PURPOSE

The purpose of University Management System is to automate the

existing manual system by the help of computerized equipment and
full-fledged computer software, fulfilling their requirements, so that
their valuable data/information can be stored for a longer period
with easy accessing and manipulation of the same. The required
software and hardware are easily available and easy to work with.
University Management System, as described above, can lead to
error free, secure, reliable and fast management system. It can assist
the user to concentrate on their other activities rather to
concentrate on the record keeping. Thus it will help organization in
better utilization of resources. The organization can maintain
computerized records without redundant entries. That means that
one need not be distracted by information that is not relevant, while
being able to reach the information. The aim is to automate its
existing manual system by the help of computerized equipment and
full-fledged computer software, fulfilling their requirements, so that
their valuable data/information can be stored for a longer period
with easy accessing and manipulation of the same. Basically the
project describes how to manage for good performance and better
system for user.

7|Page
  PROJECT SCOPE

It may help collecting perfect management in details. In a very

short time, the collection will be obvious, simple and sensible. It
will help a person to know the management of passed year
perfectly and vividly. It also helps in current all works relative to
Hospital Management System. It will be also reduced the cost of
collecting the management & collection procedure will go on
smoothly. Our project aims at Business process automation, i.e.
we have tried to computerize various processes of Hospital
Management System

 In computer system the person has to fill the various forms &
number of copies of the forms can be easily generated at a
time.
 In computer system, it is not necessary to create the manifest
but we can directly print it, which saves our time.
 To assist the staff in capturing the effort spent on their respective
working areas.
 To utilize resources in an efficient manner by increasing their
productivity through automation.
 The system generates types of information that can be used for
various purposes.
 It satisfies the user requirement.
 Be easy to understand by the user and operator.
 Be easy to operate.
 Have a good user interface.
 Be expandable.
 Delivered on schedule within the budget.

8|Page
 OBJECTIVE

 PROJECT OBJECTIVE
The main objective of the Project on Hospital Management System is
to manage the details of University, Collage, Students, Classes,
Courcer, Faculties, Semester. It manages all the information about
University. The project is totally built at administrative end and thus
only the administrator is guaranteed the access. The purpose of the
project is to build an application program to reduce the manual work
for managing the University

9|Page
ABOUT:-
MySQL CONNECTOR
To access the MySQL database from Python, you need a database
driver. MySQL Connector/Python is a standardized database driver
provided by MySQL.
MySQL Connector/Python supports almost all features provided by
MySQL version 5.7. It allows you to convert the parameter’s value
between Python and MySQL data types e.g., Python datetime and
MySQL DATETIME.
MySQL Connector/Python is designed specifically to MySQL. It sup
ports all MySQL extensions such as LIMIT clause.
[9] MySQL Connector/Python allows you to compress the data stream
between Python and MySQL database server using protocol com
pression. It supports connections using TCP/IP socket and secure
TCP/IP connection using SSL.

10 | P a g e
 MySQL
MySQL is the world's most popular open source database. With its
proven performance, reliability and ease-of-use, MySQL has become
the leading database choice for web-based applications, used by high
profile web properties including Facebook, Twitter, YouTube, Yahoo!
and many more.
Oracle drives MySQL innovation, delivering new capabilities to power
next generation web, cloud, mobile and embedded applications.
Though often associated with internet applications or web services,
MySQL was designed to be extensively compatible with other tech
nologies and architectures. The RDBMS runs on all major computing
platforms, including Unix-based operating systems, such as the myri
ad Linux distributions or Mac OS, and Windows.
MySQL’s client-server architecture means it can support a variety of
backends, as well as different programming interfaces. Data can be
directly migrated from MySQL to its forks (e.g. MariaDB), as well as
most other RDBMSs thanks to architectural and language similari
ties.
Established Oracle and third-party migration tools further allow
MySQL to move data to and from a vast set of general storage sys
tems, whether these are designed to be on-premises or cloud-based.
MySQL can be deployed in virtualized environments, distributed or
centralized, and even exists as portable standalone libraries for
learning purposes, testing, or small applications.
[10] MySQL’s wide compatibility with all these other systems and soft
ware makes it a particularly practical choice of RDBMS in most situa
tions.

11 | P a g e
 PYTHON
Python is an interpreted, object-oriented, high-level programming
language with dynamic semantics. Its high-level built in data struc
tures, combined with dynamic typing and dynamic binding; make it
very attractive for Rapid Application Development, as well as for use
as a scripting or glue language to connect existing components to
gether. Python's simple, easy to learn syntax emphasizes readability
and therefore reduces the cost of program maintenance. Python
supports modules and packages, which encourages program modu
larity and code reuse. The Python interpreter and the extensive
standard library are available in source or binary form without
charge for all major platforms, and can be freely distributed.
Often, programmers fall in love with Python because of the in
creased productivity it provides. Since there is no compilation step,
the edit-test-debug cycle is incredibly fast. Debugging Python pro
grams is easy: a bug or bad input will never cause a segmentation
fault. Instead, when the interpreter discovers an error, it raises an
exception. When the program doesn't catch the exception, the inter
preter prints a stack trace. A source level debugger allows inspection
of local and global variables, evaluation of arbitrary expressions, set
ting breakpoints, stepping through the code a line at a time, and so
on. The debugger is written in Python itself, testifying to Python's in
trospective power. On the other hand, often the quickest way to de
bug a program is to add a few print statements to the source: the
fast edit-test-debug cycle makes this simple approach very effective.

12 | P a g e
 LIST OF MODULES USED

THE PROPOSED SYSTEM CONTAINS THE FOLLOWING

MAIN MODULES: -

MODULE 1:

13 | P a g e
 DATA STRUCTURE
{LIST OF TABLES}

 Student Table :-

 College Table :-

14 | P a g e
 Course Table :-

 Faculty Table :-

15 | P a g e
 Admission Table :-

16 | P a g e
WATERFLOW MODEL

17 | P a g e
ER DIGRAM

18 | P a g e
DATA FLOW DIGARM

19 | P a g e