Important Topics of DBMS and Notes for GATE & Computer Science Engineering Exams
By BYJU'S Exam Prep
Updated on: September 25th, 2023
DBMS comes under the core subjects of the Computer Science branch. So, it is very important for CSE people to go through this subject. This subject is quite vast and covers so many concepts. In this article, DBMS is divided into topics, which are further divided into subtopics. Here is the list of important topics in DBMS one can refer while preparing the subject:
Table of content
IMPORTANT TOPICS ARE:
-
Database Design
- Introduction to keys
- Codd rules
- Overview of Functional Dependencies and Armstrong rules
- Closure and Canonical covers
- Lossless Join and Dependency Preserving Decomposition
- Normal Forms
-
ER Model
- Basic Terminologies
- Mapping Constraints
- Decomposition into Higher Normal Form
-
Relation Algebra
- Basic Operators
- Derived Operators
- Deriving Expression for Queries
-
Relational Calculus
- Tuple Relational Calculus
- Domain Relational Calculus
-
SQL (Structured Query Language)
- Data Definition lanuage
- Data Manipulation Language
- Nested Queries
- Aggregate Functions
-
File Organisation
- Types of index
- Multilevel Indexing
- B/B+ tree
-
Transaction and Concurrency Control
- ACID properties and state transition diagram
- Checkpoints
- Schedules and Types of Schedules
- Serializability
- Recoverability
- Locking Protocols
You can follow the detailed champion study plan for GATE CS 2022 from the following link:
Detailed GATE CSE 2022 Champion Study Plan
Candidates can also practice 110+ Mock tests for exams like GATE, NIELIT with BYJU’S Exam Prep Test Series check the following link:
Click Here to Avail GATE CSE Test Series!(100+ Mock Tests)
Get unlimited access to 21+ structured Live Courses all 112+ mock tests with Online Classroom Program for GATE CS & PSU Exams:
Click here to avail Online Classroom Program for Computer Science Engineering
Thanks
