Rajasthan Computer Teacher - Day 1 Study Plan

Rajasthan Computer Teacher Preparation

Day 1: DBMS Fundamentals - Your 1-Hour Study Plan

One hour. No excuses. No overthinking. Today is about DBMS — a high-yield section that repeatedly appears in PYQs. Follow this structure and stay disciplined.

PYQ Session – DBMS (40 Minutes)

  • Attempt 8–10 PYQs — nothing more.
  • Focus on reasoning: why each option is right or wrong.
  • Mark questions where your logic breaks.
  • Avoid rushing — accuracy matters more than speed.

Goal: Strengthen your fundamentals using real exam questions.

Example Concept (ER Diagram → Table Conversion)

ER Concept: Student (ID, Name, Class) → Enrollment → Course (CID, CName)

Converted Tables:

  • Student: ID (PK), Name, Class
  • Course: CID (PK), CName
  • Enrollment: ID (FK), CID (FK)

This conversion pattern appears frequently in DBMS PYQs.

Sample MCQs (Practice)

1. Which normal form removes partial dependency?

A) 1NF
B) 2NF
C) 3NF
D) BCNF

Correct Answer: B (2NF)

Explanation: 2NF removes partial dependencies by ensuring that all non-key attributes are fully functionally dependent on the primary key.

2. What does a PRIMARY KEY ensure?

A) Only uniqueness
B) Only NOT NULL
C) Uniqueness + Not Null
D) None

Correct Answer: C (Uniqueness + Not Null)

Explanation: A primary key uniquely identifies each record in a table and cannot contain NULL values.

3. Which command removes a table?

A) REMOVE TABLE
B) DROP TABLE
C) DELETE TABLE
D) ERASE TABLE

Correct Answer: B (DROP TABLE)

Explanation: The DROP TABLE command is used to remove a table definition and all its data from the database.

4. Which of the following is not a type of key?

A) Primary Key
B) Super Key
C) Candidate Key
D) Composite File

Correct Answer: D (Composite File)

Explanation: Composite File is not a type of key in database management systems.

5. A relation is in 3NF if:

A) No partial dependency
B) No transitive dependency
C) No multi-valued dependency
D) None

Correct Answer: B (No transitive dependency)

Explanation: A relation is in 3NF if it is in 2NF and has no transitive dependencies (non-prime attributes shouldn't depend on other non-prime attributes).

Notes: 5 Key Takeaways (20 Minutes)

  • Write exactly 5 bullets — no extra lines.
  • Each bullet must be readable in 10 seconds.
  • One bullet must include a mistake you corrected.
  • Avoid long theory — focus on exam-driven lines.
  • These 5 bullets become tomorrow's warmup set.

Goal: Create micro-notes that stick, not paragraphs you'll ignore.

Mini Concept (Keys & Constraints)

Primary Key, Candidate Key, Foreign Key, Unique, Not Null — stick to these.

Additional Practice MCQs

1. A table can have:

A) Multiple Primary Keys
B) Multiple Candidate Keys
C) Multiple Foreign Keys referencing itself
D) No Candidate Key

Correct Answer: B (Multiple Candidate Keys)

Explanation: A table can have multiple candidate keys, but only one primary key.

2. Which statement is correct?

A) Unique allows NULL only once
B) Primary Key = Unique + Not Null
C) Foreign Key must be a Primary Key in referencing table
D) Composite Key cannot be a Candidate Key

Correct Answer: B (Primary Key = Unique + Not Null)

Explanation: A primary key is essentially a unique constraint combined with a not null constraint.

3. In a Foreign Key constraint:

A) Child table stores Parent's PK
B) Parent table stores Child's PK
C) Child table references Parent table's PK
D) Both must use composite keys

Correct Answer: C (Child table references Parent table's PK)

Explanation: In a foreign key relationship, the child table contains a column that references the primary key of the parent table.

5 Key Takeaways

1. Primary Key Constraint

Primary Key = Unique + Not Null. A table can have only one primary key.

2. Candidate Keys

Candidate Keys = all possible keys; PK is the chosen one from these.

3. Unique Constraint

Unique allows multiple NULL values, unlike primary key.

4. Foreign Key Relationship

Foreign Key = child table column referencing parent table's PK.

5. Corrected Mistake

Earlier mistake: Unique allows only 1 NULL → Correct: allows multiple NULLs.