Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Free DBMS Notes for BCA & MCA Students 2026 — ER Diagrams to SQL

DBMS is one of the highest-weightage subjects in BCA and MCA examinations across GGSIPU, YMCA Faridabad, AKTU, and almost every Indian university offering a computing degree. It also appears regularly in placement technical rounds — SQL queries, normalisation questions, and transaction concepts are standard interview questions at TCS, Infosys, Wipro, and product companies.

Topics covered in the DBMS notes

  • ER Modelling: entities, attributes, relationships, cardinality, participation constraints, ER-to-relational mapping.
  • Normalisation: functional dependencies, 1NF, 2NF, 3NF, BCNF with worked examples and exam-style MCQs.
  • SQL: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), DQL (SELECT with JOIN, GROUP BY, HAVING, subqueries), DCL and TCL.
  • Transactions and Concurrency: ACID properties, serializability, locking protocols (2PL), timestamp-based concurrency control.
  • Indexing and Hashing: B-tree, B+ tree, dense vs sparse indexes, hash-based indexing.
  • Query Optimisation: query trees, cost estimation, relational algebra.

Who uses these notes

YMCA Faridabad BCA/MCA students follow a curriculum where DBMS is a core third-semester subject — the notes here align with the J.C. Bose University syllabus. IPU BCA / MCA students (USICT, MAIT, BPIT, MSI, MSIT) and GGSIPU-affiliated colleges also follow very similar DBMS syllabi, making these notes useful across the NCR.

Exam tips for DBMS

  1. Normalisation questions almost always appear in 10-mark or 15-mark long-answer sections — practise converting a given relation from 1NF to BCNF step by step.
  2. SQL queries with multiple JOINs and subqueries are common practical exam components — test everything in the online compiler.
  3. ACID properties and transaction states are favourite MCQ topics — memorise the state diagram.

Open the free DBMS notes and work through the ER modelling unit first — it underpins everything else in the subject.