Database Analysis Report: Centralized Library Management System

This report provides a comprehensive analysis of a centralized library management system, focusing on database design and implementation. The report begins with an introduction that highlights the importance of databases in modern businesses and the process of data extraction and statistical analysis. It then analyzes the system requirements for a centralized library system at Leeds City College, detailing the data flow, user interactions, and system processes, including the use of unique IDs and passwords for students. The report includes a context diagram, Data Flow Diagrams (DFDs), an Entity-Relationship Model (ERM), and a data dictionary to illustrate the database structure. The report discusses different technical models such as relational, network, E-R models and explains their functions. The report also addresses the implications of legal and ethical issues in database management, such as access rights and system failures, and how these issues can impact the library management system. The report concludes by summarizing the key findings and emphasizing the role of the database administrator in managing and resolving these issues. The references section includes relevant books and journals to support the analysis.

Database Analysis

Table of Contents
INTRODUCTION...........................................................................................................................1
Analyse system and provide interpretation and process of data system......................................1
Context diagram...........................................................................................................................2
DFD 1..........................................................................................................................................3
DFD 2..........................................................................................................................................4
ERM.............................................................................................................................................5
Data dictionary.............................................................................................................................5
Summary......................................................................................................................................5
Implication of legal and ethical issues.........................................................................................6
Conclusion.......................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
In today’s technological era data base plays a crucial role in every business. It defines
relationship between user and system. It is a process of extracting data and merging it. Then,
statistical analysis is done (Dennis, Wixom and Roth, 2018). It is also known as data base
modelling. It is necessary to analyze requirement of system so that data base can be developed.
Analyse system and provide interpretation and process of data system
In a college a centralised library management system is required for keeping record of
books and students. Also, it integrates various departments that are included in it. Therefore, in
order to implement a system it is necessary to identify requirements. This is because it gives an
overview about how student or user will interact with system, how data will flow, etc. besides
this, it shows the processes and data systems. In present case there are many departments in
Leeds City College. So, a centralised library management system is required (Harrington, 2016).
It will include a systematic process of data. In this each student or member of library will have
unique id and password. In addition to it, each department student will be identified with unique
code. Besides this, it requires an effective process that how book is issued. This helps in giving
description of what entire process is, which systems process data, who are the users, etc. So, by
identifying process, changes can be made according to the needs. It also helps in finding out
where user will have to interact and not.
In this system the student will first have to log in into his or her library account. Then,
details will be checked by system. By this student is able to access system. Through it, book is
searched either by name or author. The information is passed on to system. Moreover, issue and
submission date is included in it as well. The system also ensured all details. In this way library
management system works.
1

Context diagram
2

DFD 1
3

DFD 2
4

ERM
Data dictionary
Entity Data type Description
Student_id int Primary key
Book_name Varchar(50)
Student_name Varchar(50)
Summary
It is analyzed that in database there are different types of technical models available. The
model defines the logical structure of database. It shows how data is connected to each other and
how user interacts with it. There are various types of technical model in it such as relational,
network, E-R model, etc. Each model has its own attribute and entity. Furthermore, functions
and structure of model vary from each other (Hubler, Wendner and Bazant, 2015). By
5

identifying the model it is easy to deign DBMS. It acts as framework to identify what type of
DBMS system is. In similar way, processes are defined and implemented within system.
Conceptual data model – It defines what system contains. Basically, it is used by business to
define their goals. Also, the models are based on specific concept.
Logical – It defines that how system must be implemented. Architects design these models and
there is no use of DBMS in it. They are usually used in developing data structure and technical
map of rules.
Physical – In this model it describes that how system should be implemented by using DBMS.
They are developed by data base administrator and developers. Here, data base is implemented to
store, process data etc.
All models functions and process are different. The flow of data and information depends
on how user interacts with system. Generally, physical models are used with DBMS. It integrate
overall department and transform it into centralised one. Here, data is stored, accessed, etc, by
user easily in systematic way. In this model, changes can be done in process. This helps in
improving system performance.
The present model is physical data model. In this a centralised library system is
implemented. The various departments are integrated into one. This enables students or staff to
issue book. Also, the student is given personal id and password. This DBMS shows how student
interact with library and represent process in structured manner (Darwish and Selim, 2018). The
main aim is to combine each division and develop a centralised library system. By this it will be
easy for college to attain their goals and objectives.
Implication of legal and ethical issues
In data base there are many ethical and legal issues that can occur. This highly impact on
the functions and working of database. Therefore, it is necessary to identify and resolve those
issues by taking appropriate measures. The database administrator is responsible for managing
and solving all issues. He or she should also be aware about various implications of ethical and
legal issues. It support in taking proper measures to resolve issues.
They are explained below :-
Right to access information – this issue can occur as student may not be able to access certain
information. It can lead to privacy error and issues (Harrington, 2016).
6

System issues- in this there are various functions that may occur due to which system fails. It
can be related to hardware, software, etc.
There are some policies that have to be followed. This may restrict student to access
information. Besides this, there can occur security issues as well such as loss of data. So, it is
necessary to identify how confidentiality of data can be maintained. For this policies and rules
can be formed. Thus, the legal issues can highly impact on overall library management system.
The student personal data and information may get leaked. Therefore, legal issues force college
to change process of DBMS.
Conclusion
It can be concluded that library management system allows student to issue book and search
for any book as well. By implementing data base Leeds City College is able to keep records of
student and books. Usually, there are three technical models in database that are conceptual,
logical and physical. Also, there are certain ethical and legal issues that DBA must be aware of
such as right to access information, system issues, etc. so, effective measure is taken to resolve
all these.
7

REFERENCES
Books and Journals
Darwish, S.M. and Selim, H.A., 2018. Design and Analysis of an Intelligent Integrity Checking
Watermarking Scheme for Ubiquitous Database Access. International Journal of
Artificial Intelligence Research. 3(1).
Dennis, A., Wixom, B.H. and Roth, R.M., 2018. Systems analysis and design. John wiley &
sons.
Harrington, J.L., 2016. Relational database design and implementation. Morgan Kaufmann.
Hubler, M.H., Wendner, R. and Bazant, Z.P., 2015. Comprehensive database for concrete creep
and shrinkage: analysis and recommendations for testing and recording. ACI Materials
Journal. 112(4). p.547.
8