Database Management System (DBMS)

Overview of DBMS

• A Database Management System (DBMS) is a collection of interrelated data and a set of programs to access those data.
• E-DBMS database contains information relevant to an enterprise.

Characteristics of DB Systems

• DB systems can handle structured, semi-structured, and unstructured data:
  • Structured Data: Information stored in a relational database.
  • Semi-Structured Data: Data with some organizational properties that simplify analysis.
  • Unstructured Data: Data that doesn't reside in a relational database.

Data Models

• Conceptual Data Model: High-level description of a database structure, often using diagrams.
• Physical Data Model: Describes how data is stored in computer storage media.
• Implementation Data Model: Concepts that are easily understood by end users.

Examples of Data Models

• Network Model
• Hierarchical Model

Database Schema

• The overall design of a database system is referred to as the database schema.
• External Level: Describes the physical structure of the database.