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 to while preparing the subject:
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
Comments
write a comment