Database Management System Concepts

This study guide covers various aspects of database management systems, starting with the introduction to database management systems in 1960. It explains the importance of using a database management system for organization, repeatability, consistency, and well-ordered development. The guide discusses hierarchical data models, which are based on arrays like trees, and relational data models, which reduce complexity by not requiring programmers to define accurate data paths. Additionally, it covers entity relationship models, which create relationships between different entities. The study guide concludes with an overview of the importance of entity relationship diagrams in creating relationships between entities, collecting information about entities and their attributes, and visualizing real-world objects and their relationships.

BUSINESS INFORMATION SYSTEM

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
Construct Entity relationship digram of database system...........................................................3
Produce a final ERD with many to many relationships eliminated............................................5
Impact of information system in context of City college library management...........................5
Understanding of skills and Mind set needed to construct Entity relationship diagram ............6
Describe Data structure and attributes of repository...................................................................7
Analysis of Data modelling technique in City college................................................................7
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................11
INTRODUCTION...........................................................................................................................1
REFERENCES................................................................................................................................2

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. This report will discuss about the analysis and requirements of city college. It
should be included the information for identifying the specific data in the database system. It
will construct an ER Diagram and produce the final diagram but it will eliminate the many to
many relationships. However, This study will discuss about the introduction of information
system of city college. This study will describe the skills and mindsets that required to construct
the fully entity relationship diagram. It will require for describing all data structure and attributes
to the repository. Furthermore, This study will demonstrate the depth knowledge about the data
modeling techniques.
MAIN BODY
Construct Entity relationship digram of database system
Entity relationship diagram is a part of engineering that guarantee to produce high quality
of design. ER model help for providing the best communication medium between the entities.
ER diagram is a type of structural diagram that contain different connectors, symbols and
visualize the information in proper manner. ER can be drawn through the physical database
development. It is necessary to ensure the use of type that genuinely support the target of
relational database.
 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.

Entities Attributes
Members  Member register id
 Member name
 Member age
 Member phones no
 Member city
Author  Author id
 author publisher
 author name
 author no
 author type
 publication year
Book  Book id
 book name
 book price
 book issue date
 book subject

 author id
Student  Student id
 student name
 student age
 student phone no
 student city
 student department
Produce a final ERD with many to many relationships eliminated
Impact of information system in context of City college library management
Information system is generally type of technology which important for the library
management system. It helps for promoting and marketing the identification of library
competitive position. Information system is enhancing the current operation of city college in
their library management system. It assists the users to carry out the different activities in the
digital library. The effectiveness of library management which accomplished by the combination
of basic function that performed in it. Information system is change the fundamental concept of
library activities. In this way, technology is not affects the technical services of libraries but it
also provides the shape of overall services.
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.
 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 libaray
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
Mind set and skills are helped for designer to construct a dynamic ER model that meet
the objective of business. In Library system, It is required for every staff members to perform
specific role in the system to handle task in proper manner. Librarian's plays important role in the
system to divide the specific role to their staff members.
Skills-
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 fr
data. Data modeling the most important part of project to construct the structure of data in the
form of entity relationship model.
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.

Describe Data structure and attributes of repository
A well designed metadata repository is mainly contains data in proper manner. It also
stores the information about the entities and different attributes of every members those who are
issued the books in digital library. Data structure is an appropriate specified format for storing
and organizing the data. It should be included the array, files, records, tables and tree etc. It is
designed to organize the information which suits on the basis of specific purpose. In this way, it
easily accesses the data and worked with in proper ways.
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
Data modeling is a process of creating a data model and also store in the database system.
It is a conceptual representation of data objects and their association, rules etc. It helps in the
visual representation of information which enforces the enterprise rules, government policies and
compliance's on the data. It enables to maintain the consistency in terms of security, semantics
and default values. A data model is design the database system at the physical, conceptual and
physical levels. Data modelers mainly use the different models to view the same type of data. It
ensures that all the processes, relationships, data flows and entities have determined. Data
modeling stages break down into the creation of logical data model that shows specific attributes
and their relationship. There are different type of data modeling technique that used for building
data schema.
Hierarchical data Modeling-
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.
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.
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.
It is reliable and flexible for the use in terms of business process. It can be divided into
data segments that explicitly joined one entity to another by using relational tables. In this way, it
easy for programmer to compare the hierarchical model. The data is implicitly joined together.
The relational data model was coupled the SQL language and began to gain larger business
computing as a proper way to process the data.
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.
In relational modeling, All the data types are identified and change on the basis of time.
In this way, it comprises the attributes in appropriate manner. For Example- In library
management system, Student is an entity that should cover the different attributes such as last
name, age, city, first name etc. It also mapped the visual relationship between the entities, ready
to communicate with the data design and their objectives in the different members in the
development of data or maintenance.

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 mindsets that
required to construct the fully entity relationship diagram. It will require for describing all 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
Books and Journals

1

2