Database Management system Laboratory Report on
Normalizations on Library Database
A Laboratory Report/Project
Submitted in partial fulfillment for the award of the degree of
BACHELOR OF TECHNOLOGY
IN
COMPUTER SCIENCE AND ENGINEERING
By
POOJA 23X01A0501
ABRAMAINA ARAVIND 23X01A0502
ADDOJU KARTHIK 23X01A0503
ADUNURI RAHUL 23X01A0504
UNDER THE GUIDANCE OF
Dr. GANDIKOTA RAMU
Professor, Department of CSE,
Laboratory In charge of Database Management system Lab
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
NARSIMHA REDDY ENGINEERING COLLEGE
Approved By AICTE, Permanently Affiliated to JNTUH,
Accredited With NBA and NAAC-A Grade,UGC 2(f) & 12(B), Hyderabad
Sy.No.518, Maisammaguda (V), Kompally – 500100, Telangana state.
May – 2025
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
NARSIMHA REDDY ENGINEERING COLLEGE
Approved By AICTE, Permanently Affiliated to JNTUH, Accredited
With NBA and NAAC-AGrade, UGC 2(f) & 12(B), Hyderabad
Sy.No.518, Maisammaguda (V), Kompally – 500100, Telangana.
CERTIFICATE
This is to certify that the Laboratory Report/Project entitled “Normalizations on Library
Database” is the bonafide work done by
POOJA 23X01A0501
ABRAMAINA ARAVIND 23X01A0502
ADDOJU KARTHIK 23X01A0503
ADUNURI RAHUL 23X01A0504
B. Tech students of NARSIMHA REDDY ENGINEERING COLLEGE, Affiliated
to JNTUH, Hyderabad in partial fulfillment of the requirements for the award of the Degree of
BACHELOR OF TECHNOLOGY in COMPUTER SCIENCE AND ENGINEERING during
the Academic year 2024 – 2025.
Laboratory In charge Head of the Department
Dr. GANDIKOTA RAMU Dr. GANDIKOTA RAMU
Professor and Head, Professor and Head,
Department of C S E , Department of CSE,
NARASIMHA REDDY ENGINEERING COLEGE NARASIMHA REDDY ENGINEERING COLLEGE
Maisammaguda, Kompally, Secunderabad. Maisammaguda, Kompally,Secunderabad
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
NARSIMHA REDDY ENGINEERING COLLEGE
Approved By AICTE, Permanently Affiliated to JNTUH,
Accredited With NBA and NAAC-AGrade, UGC 2(f) & 12(B), Hyderabad
Sy.No.518, Maisammaguda (V), Kompally – 500100, Telangana.
DECLARATION
We hereby declare that the project work entitled “Normalizations on Library
Database”, is entirely our original work carried out under the guidance of Dr.
GANDIKOTA RAMU, Professor, Department of Computer Science and Engineering,
NARSIMHA REDDY ENGINEERING COLLEGE Affiliated to JNTUH, Hyderabad,
TG, India for the award of the degree of BACHELOR OF TECHNOLOGY in
COMPUTER SCIENCE AND ENGINEERING. The work presented in this laboratory
report/project is the result of our own efforts and has not been submitted elsewhere for the
award of any other degree or diploma.
POOJA 23X01A0501
ABRAMAINA ARAVIND 23X01A0502
ADDOJU KARTHIK 23X01A0503
ADUNURI RAHUL 23X01A0504
CONTENTS
TOPIC PAGE NO.
LIST OF FIGURES i
LIST OF TABLES ii
ABSTRACT 1
CHAPTER-1
PROJECT OVERVIEW 2
CHAPTER-2
2.1 BLOCK DIAGRAM OVERVIEW 4
CHAPTER-3
CHAPTER-4
SOFT WARE EXPLANATION 9
CHAPTER-5
PROBLEM STATEMENT EXPLANATION 12
CHAPTER-6
CONCLUSION AND FUTURE SCOPE 14
CHAPTER-7
BIBLIO GRAPHY 16
LIST OF FIGURES
FIGURE NAME PAGE NO.
2.1 BLOCK DIAGRAM OVERVIEW 4
FIGURES 8
i
LIST OF TABLES
TABLE NAME PAGE NO.
1. Relevant Components Used Instead 5
ii
ABSTRACT
The effective organization of data is crucial for the efficient
management of any database system, especially in libraries where large
volumes of information related to books, users, authors, and transactions are
handled. This project focuses on the application of database normalization
techniques to design and optimize a Library Management System.
Normalization is a systematic approach of decomposing complex database
tables to eliminate data redundancy and improve data integrity.
In this study, the library database is analyzed and structured through
different levels of normalization, from First Normal Form (1NF) up to
Boyce-Codd Normal Form (BCNF). The primary objective is to reduce
anomalies in data operations such as insertion, deletion, and updates. Key
entities such as Books, Members, Authors, Loans, and Staff are identified
and normalized to ensure relational consistency and efficient query
processing.
The normalized design not only enhances the clarity and
maintainability of the database but also supports scalability for future
enhancements. The resulting database schema provides a robust foundation
for building advanced features like digital cataloging, user history tracking,
and automated notification systems. This project demonstrates the practical
benefits of normalization in real-world database applications, especially in
academic and public libraries.
ii
