Scribd
Upload
9 views3 pages

DBMS Module 1 Introduction

The document provides an introduction to Database Management Systems (DBMS), highlighting its definition, key characteristics, advantages, and types of data models. It discusses various DBMS architectures, including 1-Tier, 2-Tier, and 3-Tier systems, and explains the Entity-Relationship (ER) model along with its components and mapping rules to the relational model. Overall, it serves as a foundational overview of DBMS concepts and structures.

Uploaded by

ammayra.sain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views3 pages

DBMS Module 1 Introduction

The document provides an introduction to Database Management Systems (DBMS), highlighting its definition, key characteristics, advantages, and types of data models. It discusses various DBMS architectures, including 1-Tier, 2-Tier, and 3-Tier systems, and explains the Entity-Relationship (ER) model along with its components and mapping rules to the relational model. Overall, it serves as a foundational overview of DBMS concepts and structures.

Uploaded by

ammayra.sain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DBMS Notes - Module 1: Introduction to DBMS

1. What is DBMS?

A Database Management System (DBMS) is software that allows users to define, create, maintain, and

control access to databases.

It provides an interface between users and the database, ensuring data is consistently organized and easily

accessible.

Key Characteristics:

- Data Abstraction and Independence

- Efficient Data Access

- Data Integrity and Security

- Data Administration

Advantages:

- Reduces Data Redundancy

- Facilitates Data Sharing

- Ensures Data Consistency

- Better Data Integration

2. Data Models

Data Models define how data is connected and how it is processed and stored.

Types:

- Hierarchical Model: Tree-like structure (Parent-Child)

- Network Model: Graph structure (Records and Sets)

- Relational Model: Tables (Relations) with rows and columns

- Object-Oriented Model: Combines object-oriented programming and databases

3. DBMS Architecture
DBMS Notes - Module 1: Introduction to DBMS

Types of Architectures:

1-Tier Architecture:

- User interacts directly with the database

- Mainly used for development

2-Tier Architecture:

- Client and server architecture

- Application on client interacts with DB server

3-Tier Architecture:

- Presentation Layer (Client), Application Layer (Server), Database Layer

- Most secure and scalable

4. ER Model

Entity-Relationship (ER) Model is a high-level conceptual data model used to define data elements and

relationships.

Components:

- Entity: Object with independent existence (e.g., Student)

- Attribute: Property of entity (e.g., Name, ID)

- Relationship: Association between entities (e.g., Enrolls)

- Key Attribute: Unique identifier (e.g., Roll No)

Types of Attributes:

- Simple, Composite, Derived, Multi-valued

Types of Relationships:

- One-to-One, One-to-Many, Many-to-Many


DBMS Notes - Module 1: Introduction to DBMS

5. Mapping ER to Relational Model

Rules for Mapping:

1. Entity -> Table

2. Attributes -> Columns

3. Key attribute -> Primary Key

4. Relationships -> Foreign Keys or separate relation

5. Multi-valued attributes -> Separate table with foreign key

6. Generalization/Specialization -> Separate tables with inheritance logic

You might also like