SQL, Normalization, Transactions & Query Optimization
CS302 – Database Systems
Undergraduate Computer Science
Comprehensive Study Guide | Exam Ready
Thorough study guide for Database Systems covering ER modeling, all SQL command categories (DDL, DML, DCL, TCL), all types of SQL joins, normalization from 1NF to BCNF with step-by-step explanations, ACID transaction properties, concurrency problems (dirty reads, phantom reads), indexing strategies, and query optimization tips. Includes clear comparison tables throughout. Essential for database exams and coursework.
Welcome! I'm Muteti Mutie, a Computer Science tutor. I create clear, exam-ready study guides and programming books for undergraduate CS students and self-taught developers — covering Python, Data Structures, Operating Systems, Databases, Networking, and more. Every document I publish is written to be practical, easy to follow, and built around what actually matters — not textbook fluff.
Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.
No worries! You can instantly pick a different document that better fits what you're looking for.
No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.
“Bought, downloaded, and aced it. It really can be that simple.”