Skip to content

References: Data Management Foundations

  1. Relational model - Wikipedia - Comprehensive treatment of Codd's relational model, relations, attributes, and integrity constraints. Foundation for the entire chapter.

  2. Database normalization - Wikipedia - Detailed coverage of 1NF through BCNF with worked examples. Directly supports the normalization MicroSim used in this chapter.

  3. ACID - Wikipedia - Clear explanation of atomicity, consistency, isolation, and durability with examples. Anchors the transaction processing section.

  4. Database System Concepts (7th Edition) - Abraham Silberschatz, Henry F. Korth, and S. Sudarshan - McGraw-Hill - The dominant academic database textbook; chapters on the relational model, SQL, and transactions match this chapter's coverage closely.

  5. SQL and Relational Theory (3rd Edition) - C. J. Date - O'Reilly - Rigorous treatment of relational theory and SQL by one of the field's pioneers; useful for students who want depth beyond the introductory level.

  6. PostgreSQL Documentation - PostgreSQL Global Development Group - Official tutorial covering SQL, schemas, joins, and transactions with hands-on examples. Excellent companion for the chapter's lab exercises.

  7. SQL Tutorial - W3Schools - Beginner-friendly interactive SQL tutorial covering the SELECT, JOIN, GROUP BY, and window functions used in this chapter's exercises.

  8. Database Design Tutorial - Lucidchart - Visual guide to ERDs, primary keys, and relationships. Pairs with the chapter's small-business ERD MicroSim.

  9. SQL Window Functions - Microsoft Learn - Authoritative reference for window functions referenced in the chapter's apply-level learning outcomes.

  10. Transaction Isolation Levels Explained - PostgreSQL Documentation - Clear explanation of isolation levels and the read-skew/write-skew anomalies covered in the chapter's MicroSim.