Update (September 2026): the 2026 BCI and SCI exams were held on 22–23 August 2026. This subject stays
free to browse until the next cycle. MeritPrep now also covers
Rajasthan CET 2026 — chapter 1 of every subject and the whole Basic Computer subject are free.
Database Management Systems is the single highest-weightage section of the BCI syllabus. Master ER modeling, normalization (1NF through BCNF), SQL, transactions, indexing, and modern database architecture with full lessons in English and Hindi, 10+ MCQs per microtopic, and 4 flashcards each.
Free preview: Chapter 1 of this subject is fully free — read every lesson, attempt every MCQ, review every flashcard. No sign-up required to read; sign in to save progress.
Syllabus & chapters
Aligned to the official RSSB BCI syllabus. Each chapter is split into microtopics, each with a lesson, a bank of MCQs and spaced-repetition flashcards, so you can learn, test and revise topic by topic.
Chapter 1
13 microtopics · 130 MCQs · 52 flashcards
ER Model
- ER Modelling — entities, attributes, relationships (foundational)
- ER Notation Conventions — symbols, drawing rules, diagram interpretation
- Strong Entity Sets — definition, properties, primary key
- Weak Entity Sets — identifying relationship, partial key, double-rectangle
- Attribute Types — simple, composite, single-valued, multi-valued
- Derived & Stored Attributes — NULL semantics, key attributes
- Relationship Sets — degree (unary/binary/ternary), relationship attributes
- Cardinality Ratios — 1:1, 1:N, M:N with examples
- Mapping Constraints — total vs partial participation
- Generalisation & Specialisation — ISA hierarchies, top-down/bottom-up
- Aggregation — when to use, examples
- ER → Relational Mapping (basic) — entities, simple attributes, 1:N, M:N
- EER Mapping — weak entities, ISA, multi-valued, composite, aggregation
Chapter 2
11 microtopics · 116 MCQs · 44 flashcards
Relational Model
- Relational Model Concepts — tuple, attribute, domain, relation, schema, instance
- Properties of Relations — set-of-tuples, attribute uniqueness, NULL semantics
- Superkey + Candidate Key — definitions, minimality
- Primary, Alternate, Foreign, Composite, Surrogate Keys
- Integrity Constraints — domain, entity, referential, key, cascade rules
- Relational Algebra — Unary Operations (sigma, pi, rho)
- Set Operations — Union, Intersection, Difference
- Cartesian Product + Division — when each applies
- Join Variants — Theta, Equi, Natural Joins
- Outer Joins + Semi/Anti Joins
- Relational Calculus — TRC + DRC + safety + RA-RC equivalence
Chapter 3
8 microtopics · 86 MCQs · 32 flashcards
SQL
- SQL Basics — syntax, data types, basic SELECT
- DDL + Constraints — CREATE/ALTER/DROP, PK/FK/CHECK/NOT NULL
- Aggregates & GROUP BY
- DML — INSERT, UPDATE, DELETE
- SELECT in depth
- SQL Joins
- Subqueries & Nested Queries
- Views, DCL & TCL
Chapter 4
8 microtopics · 81 MCQs · 32 flashcards
Normalization
- Anomalies — insert/update/delete with worked examples
- Redundancy & Normalization Overview — goals, denormalisation trade-off
- Boyce-Codd Normal Form (BCNF)
- First Normal Form (1NF)
- Functional Dependencies & Keys
- Recap, Comparison & Exam Tricks
- Second Normal Form (2NF)
- Third Normal Form (3NF)
Chapter 5
7 microtopics · 70 MCQs · 28 flashcards
Transactions
- Crash Recovery & Logging
- Deadlocks
- Isolation Levels & Concurrency Anomalies
- Lock-based Protocols & 2PL
- Schedules & Serializability
- Timestamp Ordering & MVCC
- Transactions, States & ACID
Chapter 6
7 microtopics · 70 MCQs · 28 flashcards
Indexing & Hashing
- B+ Trees
- B-Trees
- Dynamic Hashing
- File Organization
- Index Selection & Cost Estimation
- Single-Level Indexes
- Static Hashing
Chapter 7
4 microtopics · 40 MCQs · 16 flashcards
Query Processing
- QP Pipeline + Heuristic + Cost-Based Optimization
- Selection + Projection + Other Operations
- Join Algorithms — Nested-loop, Sort-merge, Hash
- External Sort-Merge
Chapter 8
4 microtopics · 40 MCQs · 16 flashcards
Database Architecture
- Three-Schema Architecture + Data Independence (Logical & Physical)
- DBMS Components + Client-Server Tiers (1/2/3/n-tier)
- Database Languages — DDL/DML/DCL/TCL/DQL
- Users + DBA Roles + Centralised/Distributed/Parallel DBMS
Chapter 9
5 microtopics · 52 MCQs · 20 flashcards
NoSQL Databases
- Why NoSQL + CAP Theorem
- Key-Value + Document Stores (Redis, DynamoDB, MongoDB)
- Column-Family + Graph Stores (Cassandra, Neo4j)
- ACID vs BASE + Eventual Consistency + Recap
- Selecting Right Database — SQL vs NoSQL decision + polyglot persistence
How MeritPrep helps you crack Database Management Systems
- Microtopic depth: Each concept is broken into a 5-minute focused lesson with worked examples and diagrams, not 50-page chapters.
- RSSB pattern MCQs: Every MCQ is written in the style of past Paper II questions, with detailed explanations.
- Spaced repetition: Flashcards enter your Daily Review queue with intervals tuned to keep concepts fresh through exam day.
- Mock tests: 15-Q chapter mocks plus full-syllabus mocks for Database Management Systems when you're ready.
- Bilingual: Every lesson is available in both English and Hindi.
Frequently asked questions
Is Database Management Systems content free to read?
Every Computer Instructor subject — this one included — is free to browse in full until the next recruitment cycle is announced: no account, no payment. MeritPrep's paid courses are now the Rajasthan CET tracks; see pricing.
How does this prepare me for the BCI exam?
The Database Management Systems chapters mirror the official BCI Paper II syllabus exactly. Past-year questions (PYQs) are tagged on relevant MCQs so you know which topics are highest-yield. The combination of focused microtopic lessons, RSSB-pattern practice, and spaced repetition is designed for the exam format.
Is content available in Hindi?
Yes — every lesson, MCQ, and flashcard has a Hindi version. Toggle between English and Hindi from the language button at the top of the app.