Database Management Systems — Complete Study Guide

A comprehensive, exam-ready guide to relational database fun-damentals, covering tables and keys, ER modeling, SQL (SELECT, JOIN, GROUP BY), normalization through 3NF, indexing, ACID transactions, concurrency, and database security basics. Includes annotated SQL examples, a full worked schema-design walk-through, comparison tables for commonly confused JOIN types and normal forms, a 20-term glossary, and 18 original practice questions with detailed explanations. De-signed for students in an introductory Database Systems course and anyone needing a clear, practical refresher on SQL and relational design before an exam or technical interview.