Database Management Systems Study Materials

Entities, attributes, relationships, cardinality, ER diagram notation, and converting ER to relational model.

Tables, tuples, attributes, domains, keys (primary, foreign, candidate), and relational algebra.

CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT statements and data types.

Joins (inner, outer, self), aggregate functions, GROUP BY, HAVING, subqueries, and views.

Functional dependencies, 1NF, 2NF, 3NF, BCNF — lossless decomposition and dependency preservation.

Atomicity, Consistency, Isolation, Durability, transaction states, and commit/rollback.

Serializability, locking protocols (2PL), timestamp ordering, and deadlock handling.

B-tree, B+ tree, hash indexing, disk organisation, RAID, and query processing.

Types of NoSQL (document, key-value, columnar, graph), MongoDB basics, and when to use NoSQL.

PL/SQL blocks, cursors, triggers, stored procedures, and functions.

Design phases, requirements analysis, conceptual, logical, and physical design.

OLTP vs OLAP, star schema, snowflake schema, ETL, and data mining basics.