Scribd
Upload
7 views2 pages

Dbms Notes

This document provides essential notes on Database Management Systems (DBMS), covering topics such as the definition of DBMS, types of database models, the Entity-Relationship model, normalization processes, SQL basics, and transaction properties. It highlights the advantages of using DBMS, including data security and integrity. Key concepts such as ACID properties in transactions and various normalization forms are also discussed.

Uploaded by

Rajesh Mojumder
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
7 views2 pages

Dbms Notes

This document provides essential notes on Database Management Systems (DBMS), covering topics such as the definition of DBMS, types of database models, the Entity-Relationship model, normalization processes, SQL basics, and transaction properties. It highlights the advantages of using DBMS, including data security and integrity. Key concepts such as ACID properties in transactions and various normalization forms are also discussed.

Uploaded by

Rajesh Mojumder
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

Database Management System (DBMS) Notes

This document provides basic and essential notes on DBMS for students.
1. Introduction to DBMS

A Database Management System (DBMS) is software used to store, manage, and retrieve
data efficiently.

Examples: MySQL, Oracle, SQL Server.

Advantages include data security, reduced redundancy, and better data integrity.

2. Database Models

Common types of database models include Hierarchical, Network, Relational, and


Object-Oriented models.

The Relational model is the most widely used and is based on tables.

3. ER Model

The Entity-Relationship (ER) model is used for designing databases.

Main components: Entity, Attribute, Relationship.

4. Normalization

Normalization is the process of organizing data to reduce redundancy.

Types: 1NF, 2NF, 3NF, BCNF.

5. SQL Basics

SQL (Structured Query Language) is used to interact with databases.

Basic commands: SELECT, INSERT, UPDATE, DELETE.

6. Transactions

A transaction is a sequence of operations performed as a single logical unit.

ACID properties: Atomicity, Consistency, Isolation, Durability.

You might also like