City College Library Management System: ERD and Data Analysis Report

This report provides a comprehensive analysis of the City College Library's information system. It begins with an introduction to Entity Relationship Diagrams (ERDs) and their role in database design, followed by the construction of an ERD for the library system. The report details the entities, attributes, primary keys, and foreign keys within the database, including members, authors, books, and students. It then explores the impact of the information system on the library's management, highlighting benefits such as improved efficiency and up-to-date records. The report also discusses the skills and mindsets required for constructing ERDs, including technical, problem-solving, and creative skills, as well as openness, goal-oriented thinking, and commitment. Furthermore, the report describes data structures and attributes of the repository, comparing hierarchical and relational data modeling techniques, and analyzing the use of data modeling in the City College Library. The conclusion summarizes the key findings, emphasizing the importance of ERDs and information systems in modern library management. References to relevant books and journals are also included.

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.