Section

7 pages

Data-Integrity

Foreign Keys Are Not Optional 0 Joins That Lie: The Cardinality Problem 0 Null in Sql: Three Valued Logic and the Silent Bug Factory 0 Polymorphic References Are Not Foreign Keys 0 Schema Conventions Don't Survive Without Automation 0 Uniqueness and Selectivity: The Two Numbers That Drive Query Plans 0 Where Business Logic Lives Database vs. Application 0