Open App

Index

Introduction

ER Model

Concept of keys

Relational Algebra

Database Design (Integrity Constraints, Normalization)

SQL

File Organization & Indexing

Transaction & Concurrency Control

Revision Notes

Previous Year Questions: Database Management System

All Exams > Computer Science Engineering (CSE) > Database Management System (DBMS) > All Notes

All notes of Database Management System (DBMS) for Computer Science Engineering (CSE) Exam

Introduction

Introduction of DBMS (Database Management System)

6 pages

DBMS Architecture

2 pages

1 Crore+ students have signed up on EduRev. Have you? Download the App

ER Model

ER‐Model

12 pages

ER Diagram

10 pages

Concept of keys

Entity, Sets & Keys

9 pages

Relational Algebra

Introduction to Relation Model

6 pages

Anomalies & Constraint in Relational Model

4 pages

Operators in Relational Algebra

5 pages

Relational Algebra

1 page

Relational Calculus

2 pages

Database Design (Integrity Constraints, Normalization)

Database Normalization

8 pages

Functional Dependency

8 pages

Number of Possible Super Keys in DBMS

4 pages

Lossless Decomposition

7 pages

Finding Highest Normal Form

6 pages

Equivalence of Functional Dependencies

5 pages

Canonical Cover of Functional Dependencies in DBMS

4 pages

Denormalization in Databases

1 page

Introduction of 4th & 5th Normal Form

4 pages

Redundancy in Databases

3 pages

SQL

Types of Joins

2 pages

Structured Query Language (SQL)

4 pages

Having vs Where Clause in SQL

3 pages

Database Objects in DBMS

4 pages

DDL, DQL, DML, DCL & TCL Commands

3 pages

Nested Subqueries in SQL

4 pages

File Organization & Indexing

Indexing in Databases

4 pages

File Organization

10 pages

B - Tree

10 pages

Data Warehousing

1 page

RAID (Redundant Arrays of Independent Disks)

4 pages

Data Mining

2 pages

Data Replication

3 pages

B + Tree

6 pages

Transaction & Concurrency Control

Introduction to Timestamp & Deadlock Prevention Schemes

6 pages

ACID Properties

2 pages

Concurrency Control in DBMS

4 pages

Database Recovery Techniques

9 pages

Need for Recovery

2 pages

Transaction Isolation Levels

2 pages

Types of Schedules

5 pages

Types of Schedules based Recoverability

1 page

Conflict Serializability

3 pages

Precedence Graph For Testing Conflict Serializability

3 pages

Recoverability of Schedules

2 pages

Deadlock & Starvation

5 pages

Lock Based Concurrency Control Protocol

4 pages

Two Phase Locking Protocol

7 pages

Thomas Write Rule & Timestamp based Concurrency Control

5 pages

Multiple Granularity Locking

4 pages

Graph Based Concurrency Control Protocol

2 pages

Revision Notes

ER‐Model

12 pages

Relational Model

7 pages

Transactions & Concurrency Control

13 pages

SQL

7 pages

Relational Algebra

8 pages

Integrity Constraints

3 pages

Normal Forms

11 pages

Previous Year Questions: Database Management System

Previous Year Questions: ER Model

6 pages

Previous Year Questions: Relational Schema

9 pages

Previous Year Questions: Relational Algebra

11 pages

Previous Year Questions: Normal Form

11 pages

Previous Year Questions: Transaction

20 pages

Previous Year Questions: Integrity Constraints

1 page

Previous Year Questions: SQL

18 pages

Previous Year Questions: Tuple Calculus

6 pages

Previous Year Questions: File System

8 pages

Database Management System (DBMS)

62 videos|66 docs|35 tests

Top Courses Computer Science Engineering (CSE)

Explore Courses

Signup to see your scores go up within 7 days!

Study with 1000+ FREE Docs, Videos & Tests

Continue with Google

10M+ students study on EduRev

Revision notes for Database Management System (DBMS) 2024 is part of Computer Science Engineering (CSE) exam preparation. The notes have been prepared according to the Computer Science Engineering (CSE) exam syllabus. The revision notes, tests & MCQs are made for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests here.

Notes of Database Management System (DBMS) in English & Hindi are available as part of Computer Science Engineering (CSE) exam. Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

© EduRev

Education Revolution

Follow Us

Signup to see your scores go up within 7 days!

Access 1000+ FREE Docs, Videos and Tests

Continue with Google

Takes less than 10 seconds to signup