🗄️ Database Management
CSE-303 — data models, the relational model, keys, and relational algebra.
Chapters
Lecture 1 — Introduction to Database Ready
What a database and DBMS are, DBMS vs. file processing, data abstraction & independence, database users/roles, and DBMS architectures.
Lecture 2 — Data Models & Relational Algebra Ready
Data models, DDL/DML/DCL/TCL, the relational model, keys, and the 6+ relational-algebra operators — with interactive playgrounds.
Lecture 3 — ER Model & ER Diagram Ready
Entities & attributes, keys, relationship sets, degree, mapping cardinality, participation, weak entities, ER-diagram notation, and EER concepts.
Lecture 4 — Introduction to SQL Ready
SQL end-to-end: DDL & domain types, CREATE TABLE + constraints, INSERT/UPDATE/DELETE with CASE, the SELECT–FROM–WHERE query, string & ordering ops, aggregates with GROUP BY/HAVING, nulls, set operations, and nested subqueries.
Lecture 5 — Intermediate SQL Ready
Join expressions and outer joins, views (including materialized views), integrity constraints with cascading actions, SQL data types & domains, index creation, and authorization with GRANT/REVOKE and roles.
Lecture 6 — SQL Advanced: Triggers & Functions Ready
Triggers end-to-end (why, MySQL syntax, OLD/NEW, all six timing × event examples) and stored functions including table functions.
Lecture 7 — Functional Dependencies & Normalization Ready
Functional dependencies, the three anomalies, 1NF → 2NF → 3NF (informal and formal), BCNF including the classic 3NF-but-not-BCNF table, and validation with merits & demerits.
Lecture 8 — Indexing & Hashing Ready
What an index is and costs, the eight evaluation metrics (with a live selectivity calculator), the ten index types, and B-Tree / B+ Tree construction step by step.
Lecture 9 — Storage & RAID Ready
Physical storage media and the storage hierarchy, RAID reliability via redundancy (with a live MTTDL calculator), performance via parallelism, and RAID levels 0–6 with a live parity/recovery calculator.
Progressive Project — University HR Database Ready
The full 120-mark CSE 303 project solved: ER design, MySQL schema + queries + triggers + access control, RAID-4 recovery, normalization to 3NF, B/B+ trees — plus a viva question bank.
Midterm Exam Prep Ready
The Spring 2026 paper worked end-to-end — all four parts (concepts, relational algebra, ER diagram, SQL) with reveal-able solutions, diagrams, and a mnemonic for every topic.
Final Exam Prep Ready
The 40-mark final decoded, plus the Spring 2026 paper solved question by question — SQL basics, views & integrity, trigger & function, RAID mapping, MTTDL and parity recovery.