Are you preparing for GATE or a job in the IT industry?
This is a blog about how to study DATABASE MANAGEMENT SYSTEM (DBMS) for GATE, and other technical interviews.
Now, first of all, before I tell you how to prepare DBMS for GATE, let me tell you about the importance of DBMS in GATE.
If you look at the GATE CSE syllabus, EVERY YEAR GATE ASKS 8-10 MARKS OF QUESTION FROM DBMS ONLY.
The main thing is that this subject does not require that much hard work. With some tricks and smart work, one can achieve 9-10 marks easily here.
AND IN THE EXAM LIKE GATE, EVERYONE KNOWS THE VALUE OF 10 MARKS.
Now, in this blog first I will list some important topics and then tell the approach to study that (WITH SOME SHORTCUT TRICKS ALSO).
Table of Contents
Now, let’s discuss some important topics in detail with shortcuts.
This topic is quite important for a technical interview. Start with database and DBMS basics. Database and DBMS are two different things. Don’t get confused as most of the students.
To improve your understanding learn why DBMS is important over file systems.
They ask the basics like 3- schema architecture components, types of attributes, a symbol of attributes, RELATIONSHIPS LIKE one to one, one to many with examples.
GATE mainly asks about attributes and relationship types from these topics.
Important subtopics – 3 schema architecture, attributes, relationship type.
This is the main topic in the whole DBMS. There are different types keys used in relational databases.
While doing normalization, you have to find the candidate key first.
Understand some of the basic examples of keys and how to find them.
Focus more on REFERENTIAL INTEGRITY, and how to find the foreign key when two tables are connected.
Check which attribute does not have any incoming edge, that attribute is an essential attribute. The essential attribute itself is a candidate key.
If that does not satisfy, then check every condition. (Try to give other attributes a chance to be candidate key and take their closure.)
TYPE OF QUESTION asked in GATE on Normalization
Some functional dependency will be given in the question along with the set. You need to find out which is the candidate key, and its normal form.
How to find the normalization form?
[Step-by-step] TRICK TO SOLVE THE PROBLEM
Remembering this simple diagram will help you answer most of the normalization questions.
Do not go deep into normalization. Only this much and some understanding about LOOSE LESS AND LOOSY DECOMPOSITION will fetch you full mark in GATE.
Are you preparing for job in IT?
Make a note of every term here. They are quite important in interviews. Interviewers usually ask about the definition of terms like ESSENTIAL ATTRIBUTE, PRIME AND NON-PRIME ATTRIBUTE, FUNCTIONAL DEPENDENCY, REDUNDANCY, CANONICAL COVER etc.
In this topic, GATE does not ask that many questions. The only thing is to just understand the meaning of “DIRTY READ”, “BLIND WRITE “, etc. This will help you later in Database Transaction.
But in a technical interview, they stress much on this part. Questions like- what is a transaction? and how to avoid its concurrency problem? are very common questions.
You can also expect some questions from ACID properties in DBMS.
This is again one of the most important topics for GATE. You have to learn about different types of read-write conflict in DBMS transaction.
Few points to remember while solving questions from this topic:
Tricks to solve conflict serializability problems:
This topic is quite simple. GATE ask theory question from this, like drawbacks of Conservative 2PL, the difference between all of them, etc.
Some imp points to remember:
Join operation is used to joins the multiple rows from the two or more tables. It is easy to remember if you visualize it using this simple Venn diagram as below.
In an interview, interviewer can ask you questions from this topics.
Some important points to remember about DBMS joins.
THAT’S IT. FOCUS ON THESE IMPORTANT TOPICS. THE SAME PATTERN is REPEATING ALMOST EVERY YEAR.
If you are preparing for GATE, follow self study plan to crack GATE.
HOPE IT HELPS you to prepare DBMS for GATE. In case of any questions, ask me in the comment section below.