Visvesvaraya Technological University, Belgavi–590014

“Jnana Sangama”, Belagavi-590014, Karnataka, India

MINI PROJECT REPORT

ON
“ Management System”
As prescribed by VTU for fifth semester mini project for the award of

DBMS WITH MINI PROJECT LABORATORY

FOR
BACHELOR OF ENGINEERING
IN
COMPUTER SCIENCE AND ENGINEERING

For the Academic year

2023-2024
Submitted By:

AAA 4SH21CS0
AAA 4SH21CS0

Under the Guidance of

Ms. AMULYA
Asst. professor,
Department of CSE

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

SHREE DEVI INSTITUTE OF TECHNOLOGY

KENJAR, MANGALURU-574142
 SHREE DEVI INSTITUTE OF TECHNOLOGY

(An Institution under VTU, Belagavi)

MANGALURU -574 142

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

CERTIFICATE
Certified that the project work entitled “HOSTEL MANAGEMENT SYSTEM” is a
bonafide work carried out by AAA, AAA bearing USN’s 4SH21CS0 , 4SH21CS0 respectively in
partial fulfillment for the award of degree of Bachelor of Engineering in computer Science and
Engineering of the Visvesvaraya Technological University, Belagavi during year 2023-2024. It is
certified that all corrections/suggestions indicated for Internal Assessment have been incorporated
in the report deposited in the departmental library. The project report has been approved as it
satisfies the academic requirements in respect of project work prescribed for the degree of
Bachelor of Engineering.

____________________ ___________________
Signature of the Guide Signature of HOD
Ms. Amulya Prof.Anand S Uppar
Asst. Professor Head of the department

EXTERNAL VIVA

Name of the Examiners Signature with Date

 1. ……….……..………. .……………………….

2. .……………………… ………………………..

SHREE DEVI INSTITUTE OF TECHNOLOGY

KENJAR, MANGALURU-574142
Department of Computer Science and Engineering

DECLARATION
We AAA, AAA bearing USN’s 4SH21CS0 , 4SH21CS0 respectively, students of fifth semester
Bachelor of Engineering, Computer Science and Engineering, Shree Devi institute of Technology
Mangaluru declare that mini project work entitled ”PROJECT NAME” has been duly executed by
us under the guidance of Ms . Amulya, Asst. Professor, Department of Computer Science and Engineering,
Shree Devi Institute Of Technology, Mangaluru and submitted for the requirements for 5th semester Database
Management System with Mini project of Bachelor of Engineering in Computer Science and
Engineering during the year 2023-2024.

Date: AAA (4SH21CS0 )

Place: Mangaluru AAA(4SH21CS0 )

ABSTRACT
 ACKNOWLEDGMENT
A successful project is a fruitful culmination of efforts of many people. Some directly involved
and others who have quietly encouraged and extended their invaluable support throughout its
progress.

We would also like to convey our heartfelt thanks to our Management for providing us with the
good infrastructure laboratory facility, qualified and inspiring staff whose guidance was of great
help in successful completion of this project.

We are extremely grateful and thankful to our beloved Principal Dr. K E Prakash for providing a
congenial atmosphere and also the necessary facilities for achieving the cherished goal.

We are very thankful to our Director Dr. K.E Prakash for his unconditional support for the
successful completion of our project.

We feel delighted to have this page to express my sincere thanks and deep appreciation to Prof.
Anand S Uppar, Head of the Department, Computer Science and Engineering, for his
valuable guidance, keen insert and constant encouragement throughout the entire period of this
project work.

We would like to thank my project guide Ms. Amulya, guide, Assistant Professor, Computer
Science & Engineering for her valuable guidance and constant support throughout the project
work.

We are thankful to all teaching and non-teaching staff for allowing us to successfully carryout the
project work.

Finally, we also thank our family and friends who provided a lot of support in this project work.

AAA

AAA
 TABLE OF CONTENT
1. Introduction 1
1.1 Introduction to DBMS 1

1.2 Introduction to project 1

2. System Requirement Specification 2

2.1 Software requirement 2

2.2 Hardware requirement 2

3. System Design 3-7

3.1 ER Diagram 3

3.2 Relational Schema 4

3.3 Flow Chart 5

3.4 Use Case Diagram 6

3.5 Data Table 7

4. Implementation 8-10

4.1 Basic SQL Command with brief explanation 8-9

4.2 Modules Description 10

5. Result and Analysis 11-15

5.1 Snapshot 11-15

6. Conclusion 16

7. Bibliography 17
Management System 2023-24

CHAPTER 1

INTRODUCTION
1.1 Introduction to DBMS

Database management system is an organized collection of related data, typically stored n disk,
and accessible by possibly many concurrent users. A database management system (DBMS) is a
set of programs that manages any number of data bases.

A database management system is responsible for accessing the data, inserting, deleting, and
updating the data and many more. A DBMS supports user interface packages.

1.2 Introduction to PROJECT

5th SEM CSE, SDIT 1

Management System 2023-24

CHAPTER 2

SYSTEM REQUIRMENT SPECIFICATION

A software requirement definition is an abstract description of the services which the system
should provide, and the constraints under which the system must operate. It should only
specify the external behavior of the system.

2.1 SOFTWARE REQUIRMENTS

We are going to perform the project in windows OS. Any version of windows as window XP,
windows 7, windows 10.. The system should have minimum ram of 256MBb as well as minimum
storage capacity of 15GB. It uses HTML and CSS for front-end and PHP for back-end., for
database it uses MySQLI. For development purpose XAAMP is used incorporating its Apache
server and MySQL.

Software requirements:

 Front end: HTML, CSS supported browser, Visual Studio Code for development
 Back end: MySQLI
 Language: HTML, CSS, PHP

2.2 HARDWARE REQUIREMENTS

The hardware requirements depends on the what processor we use for project. As we are making
this project by using the windows processor as with the Intel core processor with any of those. The
laptop we use for project must contain these kind of features such as RAM is about 25GB or higher
and the hard disk of about 80GB or higher than that which should make the process easier way.

Hardware requirements

 Processor - Intel(R) core (TM)or higher

 RAM - 4GB or higher
 Hard Disc - 80GB or higher

5th SEM CSE, SDIT 2

Management System 2023-24

CHAPTER3

SYSTEM DESIGN
3.1 ER DIAGRAM

Fig:3.2.1 ER diagram
An entity relationship diagram shows the relationship of entity sets stored in a database. An entity
in this context is a component of data. In other words, ER diagrams illustrate the logical structure
of databases. At first glance an entity relationship diagrams looks very much like a flowchart. It is
the specialized symbol, and the meaning of those symbols, that make it unique.

5th SEM CSE, SDIT 3

Management System 2023-24

3.2 RELATIONAL SCHEMA

Fig 3.2.1 Relational Schema

In the relational schema we use some boxes to enter the values we have and the these boxes
contains the attributes. As the above diagram says us that card in this schema includes Id,
card_type, and certeriia.

There are primary key in this schema which will be in another table which means it’s become the
foreign key. For example Id is a primary key which will be in other table called cardholder then it
will become the foreign key.

5th SEM CSE, SDIT 4

Management System 2023-24

3.3 FLOW CHART

Fig 3.3.1 Flow chart

5th SEM CSE, SDIT 5

Management System 2023-24

3.4 USE CASE DIAGRAM

Fig 3.4.1 Use case diagram

Use case diagram are usually referred to as behavior diagrams used to describe a set of actions that
some systems should or can perform in collaboration with one or more external users of the
system. Each use case should provide some observable and valuable result to the actors or other
stakeholders.

5th SEM CSE, SDIT 6

Management System 2023-24

3.5 TABLE DESCRIPTION

ADMIN LOGIN

FIELD NAME DATA TYPE DESCRIPTION

admin_id Varchar(10) Not null
password Varchar(10) Null

5th SEM CSE, SDIT 7

Management System 2023-24

CHAPTER 4

IMPLEMENTATION
4.1 Basic SQL commands with brief explanation

The Insert operation

SYNTAX

INSERT into TABLE NAME values (attribute1,attribute2,attribute3…………..attribute

n(value1,value2…………..value n));

Or

INSERT into TABLE NAME values(value1,value2……value n);

5th SEM CSE, SDIT 8

Management System 2023-24

CHAPTER 5

RESULTS AND ANALYSIS

5.1 Snapshots

Fig 5.1.1

5th SEM CSE, SDIT 9

Management System 2023-24

CHAPTER 6

CONCLUSION
When looking for solid HOSTEL MANAGEMENT SYSTEM software, you want to find a
solution that gives you the easy way of booking tickets. Naturally you first want to find the
software that meets your needs, both now and in the future. Engineering is based on designing
different projects. Nowadays most products and system are becoming more complex in nature, and
there is an increasing demand relative to new technology application at a time when our natural
resources are dwindling” now that’s where engineering jumps in. Business depending on natural
resources is no longer in a safe position. Engineering and engineers are not only useful for the
technologies and machineries in the business world, but it is also constructive in different
components of business such as entertainment, telecommunication and etc…

The entire project has been developed and deployed as per the requirements stated by the users. It
is found to be bug free as per the testing standards that are implemented. And any specification-
untraced error concentrated in the coming versions, which are planned to be developed in near
future.

Finally, we like to conclude that we put all our efforts throughout the development of our project
and tried to fulfill most of the requirements of the user.

5th SEM CSE, SDIT 10

Management System 2023-24

BIBILOGRAPHY
REFERED BOOKS

 Database systems Models, Languages, Desgin and Application Programing Ramez Elmarsi
and Shamkant B.Navathe,7th Edition,Pearson.
 Jhon sharp, Microsoft Visual C# step by step, 8th Edition,PHI learning Pvt,Ltd 2016

Referred websites
 www.stackoverflow.com
 www.google.come
 www.w3schools.com

5th SEM CSE, SDIT 11