I

VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“Jnana Sangama”, Belagavi - 590 018.

A PROJECT REPORT
ON

“HOSTEL STUDENT TRACKING SYSTEM”

Submitted in partial fulfilment of the requirements for the Database

Management Systems Laboratory (18CSL58) course of the 5th semester

Bachelor of Engineering
In
Computer Science & Engineering
Submitted By
1. ANUSHA BHAT (4AI19CS015)
[Link] S P (4AI19CS023)

Under the guidance of

MR. GOPALKRISHNA [Link].
Assistant Professor

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

ADICHUNCHANAGIRI INSTITUTE OF TECHNOLOGY
(Affiliated to VTU, Belagavi and Approved by AICTE, New Delhi)
Chikkamagaluru – 577 102, Karnataka, India.
2021 – 2022
 II

ADICHUNCHANAGIRI INSTITUTE OF TECHNOLOGY

(Affiliated to VTU, Belagavi and Approved by AICTE, New Delhi)
Chikkamagaluru- 577 102, Karnataka, India.

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

CERTIFICATE
This is to certify that the project work entitled “HOSTEL STUDENT TRACKING SYSTEM” is a
Bonafede work carried out ANUSHA BHAT(4AI19CS015) CHINMAYI S P (4AI19CS023) in partial
fulfillment for the Database Management Systems Laboratory (18CSL58) course of 5th semester
Bachelor of Engineering in Computer Science and Engineering of the Visvesvaraya Technological
University, Belagavi during the academic year 2021-22. It is certified that all corrections and suggestions
indicated for Internal Assessment have been incorporated in the report deposited in the department library.
The project report has been approved as it satisfies the academic requirements in respect of Project Work
prescribed for the said degree.

Signature of the Guide Signature of the HOD

MR. GOPALKRISHNA [Link]. Dr. Pushpa Ravikumar B.E., MTech., Ph.D.,
Assistant Professor Professor & Head of department

External Examiner

Signature with date

1.

2.
 i

ABSTRACT

A database management system (DBMS) is a software package with computer programs that control
the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases
for various applications by database administrators (DBAs) and other specialists. Information retrieval
emerged as independent research area from traditional database management system more than a decade ago.
This was driven by the increasing functional requirements that modern full text search engines have to meet.

Current database management systems (DBMS) are not capable of supporting such flexibility.
However, with the increase of data to be indexed and retrieved and the increasing heavy workloads, modern
search engines suffer from Scalability, reliability, distribution and performance problems. We present a new
and simple way for integration and compare the performance of our system to the current implementations
based on storing the full text index directly on the file system.
 ii

ACKNOWLEDGEMENTS
We express our humble Pranamas to his holiness Parama Poojya Jagadguru Padmabushana Sri Sri Sri Dr.
Balagangadharanatha Mahaswamiji and Parama Poojya Jagadguru Sri Sri Sri Dr. Nirmalanandanatha
Mahaswamiji and also to Sri Sri Gunanatha Swamiji, Sringeri Branch, Chikkamagaluru who have showered
their blessings on us for framing our career successfully.

We are deeply indebted to our honorable Director Dr. C K Subbaraya for creating the right kind of care
and ambience.

We are thankful to our beloved Principal Dr. C T Jayadeva for inspiring us to achieve greater endeavors in
all aspects of learning.

We express our deepest gratitude to Dr. Pushpa Ravikumar, Professor & Head, Department of Computer
Science & Engineering for her valuable guidance, suggestions and constant encouragement without which
success of our project work would have been difficult.

We are thankful to our guide Dr. Varun E. Asst. Professor, Dept. of Computer Science &
Engineering, AIT, Chikkmagaluru and, Asst. Professor, Dept. of Computer Science & Engineering, AIT,
Chikkmagaluru for their inspiration and lively correspondence for carrying our project work.

We would like to thank our beloved parents for their support, encouragement and blessings.

And last but not least, we would like to express our heartfelt thanks to all teaching and non-teaching staff of
CS&E Department and our friends who have rendered their help, motivation and support.

1. ANUSHA BHAT (4AI19CS015)

2. CHINMAYI S P (4AI19CS023)
 iii

Table of Contents

Abstract i

Acknowledgements ii

Table of Content iii

List of Figures iv

List of Tables v

Chapters Page No.

1. INTRODUCTION 1

1.1. Database management system architecture ` 2

2. SOFTWARE REQUIREMENTS SPECIFICATION 3

2.1 Overall Description 3

2.2 Specific Requirements 4

2.2.1 Software Requirements 4 2.2.2

Hardware Requirements 4

3. DATABASE DESIGN 5

3.1 E-R Diagram 6

3.2 Relational Schema 7

4. IMPLEMENTATIONS 8

4.1 RDBMS Tables and their Description 8

4.2 Connecting to MYSQL using mysql connector Code 11

4.3 Tkinter Code to Create Desktop application 11

4.4 Query to Retrieve Data from DB to Display 12

5. RESULTS 14

6. CONCLUSION AND FUTURE ENHANCEMENT 18

6.1 Conclusion 18

6.2 Future Enhancement 18

REFERENCES 19
 iv

List of Figures
Figure No. Figure Name Page No.

Figure 1.1 The database management system architecture 2

Figure 3.1 E-R Diagram Notations 5

Figure 3.2 E-R diagram of Student database 6

Figure 3.3 Relational Schema Diagram 7

List of snapshots

Snapshot no. Snapshot Name Page No.

Snapshot 4.1 Snapshot of list of tables in hostel database 8

Snapshot5.1 displays for Hostel Database 14

Snapshot5.2 displays hostel login page 14

Snapshot5.3 displays options for login and logout page 15

Snapshot5.4 displays menu 15

Snapshot5.5 displays insertion page 16

Snapshot5.6 displays updation page 16

Snapshot5.7 displays the fee details page 17

Snapshot5.8 displays the student login page 17

 v

List of Tables

Table No. Table Name Page No.

Table 4.2 Student Details 8

Table 4.3 Rooms Details 9

Table 4.4 Login Details 9

Table 4.5 Logout Details 10

Table 4.6 Fee Details 10

 1

Chapter 1

INTRODUCTION

The data is scattered across multiple transactional systems, so we have to extract it from those
systems, transform it into a standardized format and finally load it into a central repository called a data
warehouse. The data has to be reorganized so that it is presented to the users in an understandable way.

“The database Management System” is a system that manages databases and organizes the data, so
that it can be easily retrieved by the users. This system can be used to manage transactional databases, such
as HR systems, banking systems, hospital systems and so on. This project is typically optimized for
performing transactions and it provides discrete pieces of information for the users.

The database management system organizes the files to give user more control over their data. The
system makes it possible for users to create, edit and update data in database files. Once created, the system
makes it possible to store and retrieve data from those database files. It provides functions such as
concurrency, security, backup, integrity and data description. It also provides reliability. Database
administrators are responsible for creating backups of databases, controlling access and, in general, making
sure it works the way it was intended.

The system provides automated methods to create, store and retrieve data and also can make tedious
manual tasks a thing of the past. A data base system reduces data redundancy and inconsistency. It allows
for concurrent access by multiple users, each with their own specific role. Some users only need to view the
data, some contribute to adding new data, while others design and manages the database- all at the same
time.

1.1 Database Management System Architecture

The design of a database management system depends on its architecture. It can be centralized or
decentralized or hierarchical. The architecture of a database management system can be seen as either single
tier or multi-tier. An n-tier architecture divides the whole system into related but independent n modules,
which can be independently modified, altered, changed, or replaced.
 2

Figure 1.1: The Database Management System Architecture.

 3

Chapter 2

SOFTWARE REQUIREMENT SEPECIFICATION

Software Requirement Specifications (SRS) is an important part of software development process.

SRS includes overall description, functional requirements, supportability, performance requirement, design
constraints, etc. for any applications. These contents are very much useful in fulfilling the goals while
implementing software projects.

2.1 Overall Description

This project is to help the organizations to organize the huge amount of data and manipulate it as
required. . The requirement Specification is a document that describes the external and internal requirements
for any system. The Requirements analyst has to identify the requirements by talking to the clients and
understanding their needs. The inputs are to be gathered from different resources to build the system based
on the different requirements. The Requirements phase translates the ideas of the clients into a formal
document. This software helps in tracking details in various sectors such as banks, library, universities,
hospitals, shops etc. The main goal of the software is manage the data efficiently

2.2 Specific Requirements

Many requirements represent stakeholder-defined characteristics the absence of which will result in a
major or even fatal deficiency. Others represent features that may be implemented if time and budget
permits. The requirements must specify a level of importance. The specification may include a set of use
cases that describe interactions the users will have with the software. It should also include the specifications
of hardware and software that are used for building the software.

2.2.1 Software Requirements

As previously mentioned there are many software that will be part of this project and all of them are
required for development.

1.1 [Link] MySQL

It is an open source Relational Database Management System (RDBMS) that is under the GNU GPL
and is one of the most widely used. It also allows to scale the project without much overhead. It also has
many features such as high availability, query caching, cross platform support and security make it a good
candidate for deployment. We will be using MySQL version 5.7.14 which is the latest version.
 4

1.2 [Link] PYTHON TKINTER

Tkinter is the de facto way in Python to create Graphical User interfaces (GUIs) and is included in all standard
Python Distributions. In fact, it's the only framework built into the Python standard library.
 Operating System : WINDOWS 10.

 Back End : MySQL.

 Front End : PYTHON (TKINTER)

 Database Connectivity : MYSQL CONNECTOR

 Server : MYSQL

2.2.2 Hardware Requirements

Most of the current computer have enough specification to implement a database. But we need to
mention some minimal requirement. These would be the minimum specifications to run the DBMS project.
Use cases that describe interactions the users will have with the software

[Link] Processor Requirement

A basic fast processor is essential for efficient handling of load during server time and development
time. A processor with minimum 2 cores can handle the workload. Minimum requirement processor is a
Pentium 4(P4). Recommended processor is one with 4 cores like core i5 Sandy Bridge with larger L3 cache.

[Link] Memory Requirements

The RAM memory will be needed to efficiently run the server and the front end, hence at least 2GB of
DDR3 RAM would be necessary.

[Link] Disk Requirement

Python require 100MB of disk space. MySQL requires 1.3GB for Enterprise running. So in total a
minimum of 2GB disk space is required.

 Intel I3 or Above

 2GB RAM

 2GB disc space

 Microsoft controllable 101 or more keyboard

 5

Chapter 3

DATABASE DESIGN

3.1 E-R Diagram

An entity–relationship model (ER model) describes inter-related things of interest in a specific

domain of knowledge. An ER model is composed of entity types (which classify the things of interest) and
specifies relationships that can exist between instances of those entity types.

ER diagram should have mainly 3 components namely, entity, attribute, relationship. The following
notations can be used for drawing an ER diagram.

Figure 3.1: E-R Diagram Notations.

Figure 3.2 shows the sample ER diagram which consists of four entities Employee, Department, Project,
Dependent related by the relations worksfor, manages, workson, controls as wells as. Dependents Of. Each
entity consists of attributes. In the below E-R diagram Dependents is the weak entity.
 6

Figure 3.2: E-R diagram.

3.2 Relational Schema

The relational schema diagram gives the relation of one entity with another as well as the
information about the key constraints. The below figure is a sample relational schema diagram in which the
attributes that are underlined are the primary key and the arrow line is used to represent the mapping.

In figure 3.3 there are totally 5 entities and 1 relation. The Ssn in Employee is the primary key which
is referred by the super_ssn of Emloyee, Mgr_ssn of Department Essn of WorksOn as well as Essn of
Department. Similarly Dnumber being the primary key in referred by Dnumber of Dept locations, Dno of
Employee as well as Dnum of Project. Dnumber and Dlocation of Dept Locations are considered as
composite primary key. Primary key Pnumber of project is referred by Pno of WorksOn.
 7

Figure 3.3: Hostel database Relational Schema.

 8

Chapter 4
IMPLEMENTATION

2 4.1 RDBMS tables and their description

Below table shows the list of tables used in implementation of the Hostel Database Management
System.

Snapshot 4.1: list of tables in hostel database management system

4.1.1 Student:

Table 4.2: student details

 9

4.1.2 Rooms:

Table 4.3: room details

4.1.3 Login:

Table 4.4: login details

 10

4.1.4 Logout:

Table 4.5: logout details

4.1.5 FEE:

Table 4.6: Fee Details

 11

4.2 Connecting to MYSQL using [Link] Code to Database

from [Link] import (connection)

mydb = [Link](
host = "localhost",
user = "root",
passwd = "Anusha@123",
database = "hostel"

)
cursor = [Link]()

4.3 Tkinter Code to Create Desktop application

def root():
root= Tk()

[Link]("700x466")
[Link]("HOSTEL DATABASE")

canvas = Canvas(root, width = 700, height = 466)

[Link]()
img =[Link]([Link]
('C:\\Users\\ASHHOKABHAT\\OneDrive\\Desktop\\dbms\\[Link]'))
canvas.create_image(20, 20, anchor=NW, image=img)

ide=Label(root,text='LOGIN PAGE',bg="#041d78",fg="#83e6e6",font=('bold',30))

[Link](x=180,y=30)

but1= Button(root, text="HOSTEL LOGIN",

font=("italic",20),bg="#83e6e6",command=lambda:[Hostellogin()])

[Link](x=190,y=170)

but2= Button(root, text="STUDENT LOGIN",

font=("italic",20),bg="#83e6e6",command=lambda:[LOG(),[Link]])
[Link](x=190,y=250)
[Link]()

root()
exit(0)
 12

4.4 MySQL Query

[Link] the fee status and paid month of each student

2. Retrieve the logout details of a student whose hostelid=1

 13

3. Retrieve details of student who login on particular date.

 14

CHAPTER 5

RESULTS 5.1 OUTPUT 1

Snapshot 5.1: Snapshot displays for Hostel Database Management

3 5.2 OUTPUT 2

Snapshot 5.2: Snapshot displays hostel login page

 15

4 5.3 OUTPUT 3

Snapshot 5.3 : Snapshot displays options for login and logout page

5 5.4 OUTPUT 4

Snapshot 5.4 : Snapshot displays menu

 16

6 5.5 OUTPUT 5

Snapshot 5.5 : Snapshot displays insertion page

7 5.6 OUTPUT 6

Snapshot 5.6 : Snapshot displays updation page

 17

8 5.7 OUTPUT 7

Snapshot 5.7 : Snapshot displays the fee details page

9 5.8 OUTPUT 8

Snapshot 5.8 : Snapshot displays the student login page

 18

Chapter 6 CONCLUSION AND FUTURE ENHANCEMENT

10 6.1 Conclusion
This project gave us the idea about, how large data are stored inside a database and
organised so that it can be retrieved easily and in a more efficient way. It also helped us in
learning to create application using Python code and connecting the back end with the front end
using the python and mysql-connector code, so that any actions that are performed in the front
end are reflected in the back end and also any modifications made at the back end can also be
seen in the front end. It also gave us complete idea about how the queries retrieve data from
multiple tables and the working of structured procedure and the triggers. This project is used to
maintain Hostel Student Tracking System efficiently.

11 6.2 Future enhancement

In future this system can be extended to the desired level so that it can adapt to the
changing technology and enhance its performance. The latest data can also be included into the
database so that the future retrieval keeps all the necessary data that has been updated. The
system can be provided with any sort of queries to perform the required actions with the help of
the schema. It also performs some computations that can be altered or modified as per the latest
requirements.
 19

12 REFERENCES
1] Elmasri, Nawathe, Fundamentals of Database Systems, Pearson Education, 5th
Edition, 2006, ISBN- 978-81-317-1625-0

[2] Raghu Ramakrishnan and Johannes Gehrke, Database

Management Systems, Tata McGraw-Hill, 3rd Edition, 2003, ISBN- 0-07-
123151-X

[3] Silberschatz, Korth and Sudarshan, Database System Concepts, Tata McGraw-
Hill, 5thEdition, 2002, ISBN- 007-124476-X

[4] Archer, B.H. (1982) The Value of Multipliers and Their Policy
Implications .Tourism Management, 3(4), 236-241

[5]Bramwell, B. (1993) .Tourism and the environment challenges and choices for the
1990s. Journal of Sustainable Tourism, 1(1),1-5.