BCA 102T Database Management System (DBMS) Notes for GGSIPU BCA Sem 2

BCA 102T Database Management System (DBMS) at a glance: GGSIPU BCA Sem 2 credits, units and exam pattern

BCA 102T is one of the 10 GGSIPU BCA Semester 2 papers. Facts below are from the official PDFs.

The official PDF numbers the units without titles, so unit names here are the notes' own.

BCA 102T Database Management System (DBMS) Notes unit-wise: 32 solved SQL queries, 15 relational algebra examples and 129 exam questions across 4 units

BCA 102T Unit 1: Introduction to DBMS and ER Model

Pages 5 to 26, topics 1.1 to 1.20. Part A covers DBMS versus file processing, the three-schema architecture, five data models and data independence. Part B builds ER diagrams with cardinality, weak entities and EER specialisation, ending in a full college ER diagram (page 21). 21 two-mark and 10 ten-mark questions.

Quick look: data independence (from page 15)

BCA 102T Unit 2: Structured Query Language (SQL)

Pages 27 to 58, topics 2.1 to 2.22. One sample COURSE and STUDENT database, with NULLs on purpose, runs through all 32 solved queries, so every answer shows real output. It covers DDL to TCL, constraints, correlated subqueries, GROUP BY with HAVING, all four joins, views, triggers and stored procedures. 24 two-mark and 10 ten-mark questions.

Quick look: NULL logic (from page 39)

BCA 102T Unit 3: Relational Model, Algebra and Normalization

Pages 59 to 84, topics 3.1 to 3.19. Codd's 12 rules come first, then 15 solved relational algebra examples, from selection to division and outer joins, each with its output. The 8-step ER-to-relational mapping is applied to the Unit 1 diagram, and one badly designed table is carried from 1NF to BCNF. 23 two-mark and 10 ten-mark questions.

Quick look: A⁺ for F = {A → BC, CD → E, B → D, E → A} (from page 76)

1. Start with A⁺ = A.
2. A → BC gives ABC.
3. B → D gives ABCD; then CD → E gives ABCDE.
4. A⁺ holds every attribute, so A is a candidate key.

BCA 102T Unit 4: Transactions, Recovery, Security, QBE and NoSQL

Pages 85 to 104, topics 4.1 to 4.15. A money transfer opens the unit in SQL, with a failed CHECK undone by ROLLBACK. Then ACID, lost update timelines, two-phase locking, backups, log-based recovery, GRANT and REVOKE, Query by Example, and four NoSQL types. 21 two-mark and 10 ten-mark questions.

Quick look: deferred vs immediate update (from page 93)

BCA 102T exam corner: 89 two-mark and 40 ten-mark questions mapped to the DBMS topics that answer them

Each question carries the topic number that answers it: "WHERE vs HAVING (2.16)" points to page 46.

The BCA 102T notes list 89 two-mark and 40 ten-mark exam-style questions across 4 units, plus 47 solved SQL and relational algebra examples with output.

• Unit 1 (10 Marks): ER diagram for a hospital with a weak entity. Pointer: double rectangle, double diamond, dashed partial key (page 20).
• Unit 2 (2 Marks): DELETE vs TRUNCATE vs DROP. Pointer: DELETE is DML; TRUNCATE keeps the structure, DROP removes it (topic 2.6).
• Unit 3 (10 Marks): A 3NF relation not in BCNF. Pointer: TEACHES(Student, Subject, Teacher) with Teacher → Subject (page 80).
• Unit 4 (2 Marks): Incremental vs differential backup. Pointer: since the last backup, versus since the last full one (page 92).

More practice sits in the BCA 102T important questions.

Super key, candidate key and primary key in DBMS: excerpt from page 18 of the BCA 102T notes

Do the BCA 102T notes cover the full GGSIPU syllabus?

Yes. Every official topic in all four units has a matching section in the notes.

Official sources: BCA first-year syllabus, batch 2024-25 onwards · BCA scheme of examination w.e.f. 2024-25

Unit IV prints "Query by Language", but course outcome CO2 names Query By Example, so the notes teach QBE (page 98).

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

Who writes and checks the BCA 102T DBMS notes?

• Prateek Talwar, author. Founder, Unnati Educations; Associate Company Secretary (ACS), ICSI, since May 2019; B.Com, University of Delhi, 2012. Profile
• Ritik Rawat, subject reviewer. Senior Full Stack Developer, Unnati Educations; B.Tech. Profile

The same team prepares GGSIPU important questions from the same official unit lists.

BCA 102T and the BCA 102P DBMS lab (practical list set by your teacher), plus other GGSIPU BCA Sem 2 papers

Most lab work comes from Unit 2: the 15 practice queries on EMP and DEPT tables (pages 57 to 58) cover constraints, filters, a correlated subquery, joins, a view, an index and a trigger.

Alongside these GGSIPU BCA Semester 2 DBMS notes, the semester has BCA 104T Object Oriented Programming using Java, BCA 106T Data Structures and Algorithms, BCA 108T Software Engineering, BCA 142T Soft Skills and BCA 192T Environment Studies, with the labs BCA 104P, 106P and 108P.

How to write BCA 102T answers: SQL with output, relational algebra expressions and ER diagrams

BCA 102T answers come in three shapes. A theory answer opens with the definition, adds a comparison table and ends with a small example. A query answer writes the SQL or relational algebra, then the output rows. A design answer is a diagram with a few lines of assumptions.

For ER diagrams the notes give six steps (page 21): nouns become entities, properties become attributes with the key underlined, verbs become relationships, write 1, N or M on every line, mark total participation with double lines and weak entities with double rectangles, then add 3 or 4 lines of assumptions.

For transaction states, draw the state diagram (Figure 4.1) first, then explain each state in one line. For relational algebra, write the expression with its operator symbols (σ, π, ⋈) and show the result relation as a small table, exactly as the 15 solved examples in Unit 3 do.

A worked query answer from page 48, of the kind asked in the ten-mark GROUP BY question: show courses with at least two students.

SELECT Course_ID, COUNT(*) AS Students  
FROM STUDENT  
WHERE Course_ID IS NOT NULL  
GROUP BY Course_ID  
HAVING COUNT(*) >= 2;

SELECT Course_ID, COUNT(*) AS Students  
FROM STUDENT  
WHERE Course_ID IS NOT NULL  
GROUP BY Course_ID  
HAVING COUNT(*) >= 2;

Output: C01 with 3 and C02 with 2. Add one line: WHERE filters rows before grouping, HAVING filters groups after it.

The Common Mistakes tables flag the slips that cost marks: Marks = NULL instead of Marks IS NULL, an aggregate inside WHERE, calling TRUNCATE a DML command, swapping σ (rows) and π (columns), and testing 2NF when the key is a single attribute. For normalisation, find closures and candidate keys first, then check partial dependency for 2NF and transitive dependency for 3NF.

Practise this format on GGSIPU BCA important questions.

BCA 102T DBMS notes FAQs

Get the full BCA 102T Database Management System (DBMS) Notes on WhatsApp

Order these notes in book form through WhatsApp. The full notes are not available as a PDF.

The printed book has 104 pages, 76 topics and 17 figures. These are DBMS notes in English. Our WhatsApp desk shares the order and delivery details.

Unnati Educations is an independent education provider based in Vikaspuri, Delhi. We are not affiliated with, authorised by, or endorsed by Guru Gobind Singh Indraprastha University (GGSIPU). 'GGSIPU' and 'IPU' are used only to describe the syllabus our notes follow. For official information, visit ipu.ac.in.