Database
Verify modelling, normalisation and SQL by result
Move continuously from conceptual models to transactions and output rows.
Find keys and relationships first
Identify candidate, primary and foreign keys before cardinality.
Normalise to remove anomalies
Explain each decomposition through insertion, deletion and update anomalies.
5 subjects · 100 itemsWritten response · 150 min40 each · 60 average
Read SQL in logical order
Trace FROM and JOIN, WHERE, GROUP BY, HAVING, SELECT and ORDER BY.
Join concurrency with recovery
Apply ACID, locking, deadlocks and logging to one failure scenario.