1/11/25, 8:44 AM Dbms - Lecture notes 3-7-
REPORT WRITING
ON
DATABASE MANAGEMENT SYSTEM
SUBMITTED TO:
about:blank 1/8
, 1/11/25, 8:44 AM Dbms - Lecture notes 3-7-
1.1Basic Concept
1.1.1Database management System
Database management System (DBMS) is a software for
creating and managing database. It provides users and
programmers with a systematic way to create, retrive, update
and manage data.
For example: ORACLE, Microsoft SQL Server, IBM, DB2, MySQL
etc.
DBMS is a collection of programs that eb\nables users to
create and maintain a database. Its main goal is to hide
underlying complexities of data management fronm users and
provide easr=y interface to them.
1.1.2ER data model:
The ER data model was developed to facilitate database design
by allowing specification of an enterprise schema that
represents the overall logical structure of a database. The entity
relationship (E-R) data model uses a collection of basic objects,
called entities, and relationships among these objects. The
Entities, their attributes and the relationships are explained
below:
Entity: An entity is a “thing” or “object” in the real world
that is distinguishable from all other objects. For example:
Each person in an enterprise is an entity. An entity has a
about:blank 2/8
REPORT WRITING
ON
DATABASE MANAGEMENT SYSTEM
SUBMITTED TO:
about:blank 1/8
, 1/11/25, 8:44 AM Dbms - Lecture notes 3-7-
1.1Basic Concept
1.1.1Database management System
Database management System (DBMS) is a software for
creating and managing database. It provides users and
programmers with a systematic way to create, retrive, update
and manage data.
For example: ORACLE, Microsoft SQL Server, IBM, DB2, MySQL
etc.
DBMS is a collection of programs that eb\nables users to
create and maintain a database. Its main goal is to hide
underlying complexities of data management fronm users and
provide easr=y interface to them.
1.1.2ER data model:
The ER data model was developed to facilitate database design
by allowing specification of an enterprise schema that
represents the overall logical structure of a database. The entity
relationship (E-R) data model uses a collection of basic objects,
called entities, and relationships among these objects. The
Entities, their attributes and the relationships are explained
below:
Entity: An entity is a “thing” or “object” in the real world
that is distinguishable from all other objects. For example:
Each person in an enterprise is an entity. An entity has a
about:blank 2/8
