Entity Relationship Diagram in Library Management System

This presentation provides an overview of the construction of Entity Relationship Diagram (ERD) in a library management system. It explains the concept of entities, attributes, primary keys, and foreign keys. The presentation also discusses the impact of information systems in the context of a city college library management system. It further explores the skills and mindset needed to construct an ERD, including technical skills, problem-solving skills, and creativity skills. Additionally, it describes the data structure and attributes of a repository and analyzes different data modeling techniques, such as hierarchical data modeling, relational data modeling, and entity relationship modeling. The presentation concludes with a summary and references for further reading.

BUSINESS INFORMATION SYSTEM

TABLE OF CONTENTS
 INTRODUCTION
 MAIN BODY
 Construct Entity relationship diagram of database system
 Produce a final ERD with many to many relationships eliminated
 Impact of information system in context of City college library management
 Understanding of skills and Mind set needed to construct Entity relationship diagram
 Describe Data structure and attributes of repository
 Analysis of Data modelling technique in City college
 CONCLUSION
 REFERENCES

INTRODUCTION
 Entity relationship diagram is basically a graphical representation of set of entities in the database
system. It is collecting all the information entities and their specific attributes. This is the high
level conceptual data model that shows a real world object and their relationship between them.

Construct Entity relationship diagram of database system
 Entity- It is a definable things and concept within system where the person, object and concepts.
When identifying the entities, It understands the logical and conceptual ideas behind the database
system.
 Attributes- An attribute is a characteristic and property that hold the entities in proper manner. It also
describes the name, type and kind of attributes.

ENTITY RELATIONSHIP DIAGRAM

CONT.
 Primary Key- It is also known as primary keyword that help in the relational database that is
unique each record. It is a type of unique identified like Book id, author id, members registration
id etc. A relational data mist be always one primary key which appears as column in the form of
relational database tables. This key must depend on the preferences of administrator which
possible to change the primary key in the database on the basis of need and requirement of users.
In Entity relational diagram, Each and every table contain primary key in the database such as
booking id, author id and member registration id etc.

CONT.
 Foreign Key- In context of relational database, A foreign key is a type of field that in one table which
is uniquely identifies as a row of another table. It is a column and group of column in the relational
database system that provide a link between the data into two tables. It acts as a cross reference
between the table because it has more preference of primary key into another tables. In ER Diagram,
Book id is represented as primary key in the book table but it shows as a foreign key into student table.
In this way, it would be created a relationship between Student and Book by using foreign key in
relational database system.

DATA DICTIONARY
Entities Attributes
Members  Member register id (PK)
 Member name
 Member age
 Member phones no
 Member city
Author  Author id (PK)
 author publisher
 author name
 author no
 author type
 publication year
Book  Book id (PK)
 book name
 book price
 book issue date
 book subject
 author id (FK)
Student  Student id (PK)
 student name
 student age
 student phone no
 student city
 student department

Impact of information system in context of City college library
management
 Information system is strategic resource which facilitates the major change in the competitive behavior
of customer and marketing. It enables an organization to achieve the competitive advantage. IT system
is key resources that link with the technology exploitation and promotion orientation.
 Tangible evidence and benefits to be accrued by the marketing a city library. This will help for
promotions of library or long term positive impacts.

CONT.
 Customer choice have become major part of business that meet the need and requirement of organizations.
 Information system help for management system to save the time of reader and library staff because it already
store all data in the database system.
 It will increase the explosion of information
 It always keeps maintain the up to date records of Books details.
 Information system give the modern based services to the users.

Understanding of skills and Mind set needed to construct Entity
relationship diagram
Skills-
 Skill is an essential for individual to explore their own ideas which requires for organization to increase the productivity and
profitability. Skill always supports the people to easily understand and learn new things.
Technical skill-
 Technical skill is the most important part of every person those who are having knowledge about the data base system. It has
cleared their logical concepts related the design of Entity model. Data modeling is concept that easily measure or evaluate the
design how the library system manage the flow of data. It is responsibility for creating the space which needed for data. Data
modeling the most important part of project to construct the structure of data in the form of entity relationship model.

CONT.
Problem solving skill-
 This type of skill is needed for designer to determine the problem related the data. It can be arranged in
the form of Structure. This is the best technique to store all the information and converted into the ER
Model. This structure is generating a relationship between the two entities.
 It is beneficial for staff members to analyze the problem which causes the entire figures and facts.
This needs that evaluate and collect data which possible to contributing towards the development of
software.

CONT.
Creativity skill-
 This type of skill is required for designer to design an effective diagram that can represented all the
information in appropriate manner. Creative skill is important for business process because it helps for
employee to implement a new ideas and design. It is beneficial for business process to handle any type
of business design in effective manner. This skill depends on the business need and requirement
because designer can implement or develop new concept on the basis of enterprise growth and
development. It should be easy and simple whereas other people can understand the concepts.

MIND SET-
 Openness- While most of designer or developer always communicate with the other employee. It is definitely
open to improve their concepts, assessing the genuine openness to improve their key areas. It depends on the
overall performance, they also trying to research the ideas that shows the base line. In this way, it will generate
positive results and outcomes.
 Desire towards the goals- Every firm is understands the importance of specific goals and objectives. Developer
can design by using suitable resources and spend time. Sometimes, it invests so much time to database design. It
is required for people to identify the important information related the designing. This type of mind set plays
important role in the business process to easily handle any type of complex situation through the desire target.

CONT.
 Belief – It is important for individual to belief on our self, there are many IT companies are hired the
efficient leaders that can help to organization to increase the growth or development. Belief in the
processional and personal development which always help in the positive and imperative improvement.
 Commitment to self improvement- This might be obvious thing that every peoples are commitment
towards the business. In this way, it can see the best leadership quality and constant moving towards
their destination. Some people is not satisfied so that they are trying to improve their skill and
knowledge. They are long life learner to learn many things in proper manner. It helps for organization to
increase the growth and success. In this way, this type of mind set is an essential for people to always
improve their quality and also give the best performance in their own areas.

Describe Data structure and attributes of repository
 Library management system is basically used the binary tree that help for easily sorting and searching
the information of management system. It is an efficient concept when all the information store in the
form of chain. It is faster technique than the other. It should be included the operations that performed
in the library management system.
 Issue a book by student
 Searching book of particular author
 Return a book

Analysis of Data modelling technique in City college
Hierarchical data Modeling
 Hierarchical data model is form of array data like tree, it is arranged one to many forms which marks
as early efforts to replace the file based system. For Example- IBM information management system is
the best example of this data model, which found in the wide range of use in enterprise process,
especially in banking sector. This data model is still exist in the extensible markup language.

CONT.
 This data modeling began to arise in 1960, and accomplishing the use of database management system.
It enables for organization to bring the repetability, consistency and also well ordered development for
data processing. Many applications and programmer can use the data model concept as a reference in
terms of communication through the data.

RELATIONAL DATA MODELING-
 This type model is beneficial for the computing language to reduce the complexity of program. It still
necessary to understand the specific physical data storage. It is the alternative of hierarchical data
model but relational model does not require the programmer to define the accurate data path. This
model was described in 1970 as technical paper by the researcher of IBM. Relational model is fix the
set of stages for the business that mainly used the relational database system.

ENTITY RELATIONSHIP MODEL-
 Entity relationship model is look like the relational model because it also creating a relationship
between different entities. This data model is become more prevalent and also closely integrated
with the data models. ER diagram is used to represent the graphically elements in database
system.

USE OF DATA MODELING-
 It is basically used for representation of data that help for improve the data analyzing. There are
different type of technique to provide a holistic picture of data. Many developer can used to create
physical database.
 It is an essential for enterprise to use the accurate model for presentation of data. The model will help
for reduce the chances of information omission. It leads to shows the incorrect outcome and results.
 The data model is better understanding of enterprise requirements and it helps in the creation of robust
design that bring the entire data of organization in same platform.

CONT.
 A project manager has better understanding and scope to manage the entire quality of products. It also
beneficial to improve the performance and efficiency.
 There are three different data model design in the database system such as logical, conceptual and
physical. It defines in the form of tables, columns, storage procedure and foreign or primary key

CONCLUSION
 As above discussion, it concluded that Entity relationship diagram is a process that help for creating
relationship between the entities. It is collecting all the information entities and their specific attributes. It
is a high level conceptual data model that shows a real world object and their relationship between them.
It summarised that the introduction of information system of city college of library management system.
This study describes the skills and mind-sets that required to construct the fully entity relationship
diagram. It also describes the data structure and attributes to the repository. However, It should be
included the information for identifying the specific data in the database system. It also constructs an ER
Diagram and produce the final diagram but it will eliminate the many to many relationships.

REFERENCES
REFERENCES
Books and Journals
 Azeroual, O., Saake, G. and Wastl, J., 2018. Data measurement in research information systems: metrics for the
evaluation of data quality. Scientometrics. 115(3). pp.1271-1290.
 Dumas, M. and et.al., 2018. Process-aware information systems. In Fundamentals of Business Process
Management (pp. 341-369). Springer, Berlin, Heidelberg.
 Olson, D.L., Johansson, B. and De Carvalho, R.A., 2018. Open source ERP business model framework. Robotics
and Computer-Integrated Manufacturing. 50. pp.30-36.
 Wang, Y., Kung, L. and Byrd, T.A., 2018. Big data analytics: Understanding its capabilities and potential benefits
for healthcare organizations. Technological Forecasting and Social Change. 126. pp.3-13.

Thank you