Entity Relationship Diagram in Library Management System

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.