► Concept & Overview of Database Management Systems (DBMS) -
Characteristics of Database system, Database Users, structured, semi-
structured and unstructured data. Data Models and Schema - Three Schem
architecture. Database Languages, Database architectures and
classification.
► ER model - Basic concepts, entity set & attributes, notations,
Relationships and constraints, cardinality, participation, notations, weak
entities, relationships of degree 3.
Page 1
, Data:
What is the Collected
difference between facts about a
data and topic or item
information?? Information: The
of combinin
comparing, a
performing
calculations on
Page 2
, Data Information ou
in… …
2021
DBM … Next year's
$1,000,000 S budget
2022
$2,000,000
Student test … Class average
scores were or school
… average
Page 3
, DBMS Definition
► Data Base Management System(DBMS)
► Is a centralized and structured set of data stored on
a computer system
► Provides facilities forretrieving, adding, modifying, and
deleting the data when required
► Provides facilities for transforming retrieved data into useful
information
► A DBMS is software that controls the storage,
organization, and retrieval of data
Page 4
Characteristics of Database system, Database Users, structured, semi-
structured and unstructured data. Data Models and Schema - Three Schem
architecture. Database Languages, Database architectures and
classification.
► ER model - Basic concepts, entity set & attributes, notations,
Relationships and constraints, cardinality, participation, notations, weak
entities, relationships of degree 3.
Page 1
, Data:
What is the Collected
difference between facts about a
data and topic or item
information?? Information: The
of combinin
comparing, a
performing
calculations on
Page 2
, Data Information ou
in… …
2021
DBM … Next year's
$1,000,000 S budget
2022
$2,000,000
Student test … Class average
scores were or school
… average
Page 3
, DBMS Definition
► Data Base Management System(DBMS)
► Is a centralized and structured set of data stored on
a computer system
► Provides facilities forretrieving, adding, modifying, and
deleting the data when required
► Provides facilities for transforming retrieved data into useful
information
► A DBMS is software that controls the storage,
organization, and retrieval of data
Page 4