MCA 108 Advanced Database Management Systems Notes for GGSIPU MCA Sem 2

Written by Prateek Talwar, Founder, Unnati Educations · Reviewed by Ritik Rawat, B.Tech, Senior Full Stack Developer · Checked against GGSIPU MCA Scheme of Examination and Detailed Syllabus (A.S. 2025-26 onwards), 13 October 2026 · Updated 14 October 2026 · Editorial policy

Scheme: MCA scheme 2025-26 (BoS USIC&T, 28/07/2025) | Applies to: MCA at affiliated institutes, academic session 2025-26 onwards | Verified against: MCA Scheme of Examination and Detailed Syllabus, 13 October 2026

MCA-108 Advanced Database Management Systems at a glance: GGSIPU MCA Sem 2 credits, units and exam pattern

MCA-108 is one of ten Core Elective-I options, chosen instead of papers such as MCA-110 or MCA-116. It sits with the other GGSIPU MCA Semester 2 papers and carries 4 credits against 3 for each core paper.

MCA-108 Advanced Database Management Systems Notes unit-wise: 70 topics, 26 diagrams and 88 important questions across 4 units

Each unit closes with 22 important questions and a Quick Revision Table. The official PDF numbers the units without titles, so the headings below use the notes' unit titles. Notes for the other papers sit under GGSIPU MCA notes; one page per unit is in the sample PDF above.

GET /college/_design/students/_view/count_by_course?group=true
-> {"rows":[{"key":"BCA","value":1},
            {"key":"MBA","value":1},
            {"key":"MCA","value":2}]}

GET /college/_design/students/_view/count_by_course?group=true
-> {"rows":[{"key":"BCA","value":1},
            {"key":"MBA","value":1},
            {"key":"MCA","value":2}]}

Two-phase commit and failure handling in distributed databases: excerpt from page 61 of the MCA-108 notes

Coordinator Ci                     Participant Sk
log <prepare T>   -- PREPARE T -->
                                   log <ready T> (or <no T>)
                  <-- READY / ABORT --
all READY? log <commit T> else <abort T>
                  -- COMMIT / ABORT -->
                                   log decision; release locks
                  <-- ACK --
log <complete T>

Coordinator Ci                     Participant Sk
log <prepare T>   -- PREPARE T -->
                                   log <ready T> (or <no T>)
                  <-- READY / ABORT --
all READY? log <commit T> else <abort T>
                  -- COMMIT / ABORT -->
                                   log decision; release locks
                  <-- ACK --
log <complete T>

MCA-108 exam corner: 48 short-answer and 40 long-answer important questions by unit

Each MCA-108 unit lists 12 short-answer and 10 long-answer important questions; the answers come from that unit's topic pages. The notes label them 2.5 and 12.5 marks, while the 2025-26 pattern gives 12 marks to Q1 and to each unit question.

The MCA-108 notes list 48 short-answer and 40 long-answer important questions across 4 units, plus 26 labelled diagrams.

One exam-style question per unit, with answer pointers:

1. Unit 1: R(A, B, C, D, E) with F = {A → BC, CD → E, B → D, E → A}: find candidate keys, the highest normal form and a BCNF decomposition. Pointer: keys A, E, BC and CD; B → D breaks BCNF, but D is prime, so R is in 3NF.
2. Unit 2: Explain the CouchDB reduce function, rereduce and grouping. Pointer: a design document with _count or _stats, the group=true output, and why a reducer must accept its own output.
3. Unit 3: Discuss OODBMS storage issues. Pointer: six headed issues and the swizzling flow from page 48.
4. Unit 4: Explain distributed query processing and the semijoin. Pointer: the four phases, then the five semijoin steps and the transfer-cost comparison on page 65.

More practice sits in the MCA-108 important questions.

Who writes and checks the MCA-108 Advanced DBMS notes?

• Prateek Talwar, author: Founder, Unnati Educations; Associate Company Secretary (ACS), ICSI, membership no. 58704, since 15 May 2019; B.Com, University of Delhi (School of Open Learning), 2012. Author profile
• Ritik Rawat, subject reviewer: B.Tech; Senior Full Stack Developer, Unnati Educations. Role on these notes: subject review of the database concepts and the SQL, CouchDB, MongoDB, ODL and XQuery snippets.

The 2026-27 edition of these GGSIPU MCA Semester 2 Advanced DBMS notes is mapped to the MCA scheme approved by the USIC&T Board of Studies on 28/07/2025. It includes CouchDB 3.3 commands, Mango queries and the MongoDB aggregation pipeline for Unit 2. Last checked 13 October 2026 under our editorial policy.

The same team prepares GGSIPU important questions for every course it covers.

Do the MCA-108 notes cover the full GGSIPU syllabus?

Yes. Every topic in the four MCA-108 units of the 2025-26 syllabus has its own section in the notes; the check found no gaps.

Official source: MCA scheme and syllabus, A.S. 2025-26 onwards.

Every course in GGSIPU notes is mapped to its official PDF the same way.

How to write MCA-108 answers: normalisation steps, cost formulas, CouchDB views and 2PC message flows

MCA-108 long answers reward clear structure far more than length. The notes' exam tips give a fixed shape for each big question type, and the shapes fit the 12-mark unit questions.

• Normalisation (page 12): list the FDs, find the candidate key by closure, mark prime and non-prime attributes, test each normal form in order, decompose with keys underlined, and state that the result is lossless.
• Join algorithms (page 16): nested-loop pseudo-code, each cost formula, the comparison table, one numerical.
• EER diagrams (page 7): draw the circle with d or o, show total or partial participation, and write inherited attributes in words.
• CouchDB views (page 32): write the design document JSON with both map and reduce, show the group=true output, and mention rereduce.
• 2PC (page 64): both phases with the message-flow figure, the failure table, then the blocking problem and how 3PC removes it.

Q1 is compulsory and spans the whole syllabus, so it rewards breadth. Read the four Quick Revision Tables (pages 20, 37, 54 and 71) the night before; each row is a ready two-line answer, such as "Lossless test: (R1 ∩ R2) → R1 or (R1 ∩ R2) → R2" or "3PC: CanCommit, PreCommit, DoCommit; non-blocking, no partitions".

For short answers, give a one-line definition and one example from the notes, such as _rev for CouchDB revisions or a Datalog ancestor rule for deductive databases. Practise this format on GGSIPU MCA important questions.

MCA-108 and the MCA-168 ADBMS lab, plus other GGSIPU MCA Sem 2 papers

If MCA-108 is your Core Elective-I, the matching practical is MCA-168, the Advanced Database Management Systems Lab (MCA-168 ADBMS lab notes). The official PDF gives this lab outcomes, not a practical list, so here is how the units feed them:

• Lab CO1, ER and EER design → Unit 1, pages 6-7
• Lab CO2 and CO3, NoSQL types and MongoDB commands → Unit 2, pages 24-26 and 33
• Lab CO4, XML attributes, nested queries and XQuery → Unit 3, pages 49-51

The core Semester 2 papers are MCA-102 Data and File Structures, MCA-104 Object Oriented Software Engineering and MCA-106 Python Programming, with labs MCA-162 to MCA-166 and MCA-170 Minor Project-II.

Open Elective-I offers MCA-128 Digital Marketing, MCA-130 Management Information System, MCA-132 Management Principles and Organizational Behavior and MCA-134 Finance and Accounting.

MCA-108 Advanced DBMS notes FAQs

Get the full MCA-108 Advanced Database Management Systems Notes on WhatsApp

The full MCA-108 Advanced DBMS IPU notes come only as a printed book, ordered on WhatsApp; they are not available as a PDF.

Format: a 72-page printed book of Advanced Database Management Systems notes in English, with a Quick Revision Table after every unit. Delivery: within 5 to 7 days at most; the exact time may vary with your location.

Order the MCA-108 notes book on WhatsApp (4 units, 72 pages)