Notes
Study notes and supporting materials for Database Management System.
1. Transaction Management and ACID Properties
Study notes covering transaction states, Atomicity, Consistency, Isolation, Durability, concurrent access anomalies, and recovery mechanisms.
2. Entity-Relationship (E-R) Modeling
Comprehensive lecture slides, complete reference notes (A-Z), case studies, and practice problems for designing entity sets, attributes, relationships, cardinality ratios, and converting E-R diagrams into relational tables.
3. Intermediate SQL: Joins and Views
In-depth textbook reference on inner joins, natural joins, outer joins (left, right, full), view definitions, updatable views, and materialized views.
4. Relational Database Normalization
Core concepts of functional dependencies, attribute closure, candidate keys, insertion/deletion/update anomalies, First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), and practice decomposition sheets.
5. PL/SQL Programming: Blocks, Cursors, and Triggers
Complete guide to Oracle PL/SQL programming: anonymous blocks, control flow, explicit cursors with loop constructs, stored procedures, functions, packages, and row-level vs. statement-level database triggers.
6. Advanced SQL and Subqueries
Reference slides and problem sets covering single-row subqueries, multi-row subqueries (IN, NOT IN, ANY, ALL), correlated subqueries (EXISTS, NOT EXISTS), and scalar subqueries.