Contents
Database Systems We Considered
Where to Find the Samples on GitHub
Item 1: Verify That All Tables Have a Primary Key
Item 2: Eliminate Redundant Storage of Data Items
Item 3: Get Rid of Repeating Groups
Item 4: Store Only One Property per Column
Item 5: Understand Why Storing Calculated Data Is Usually a Bad Idea
Item 6: Define Foreign Keys to Protect Referential Integrity
Item 7: Be Sure Your Table Relationships Make Sense
Item 8: When 3NF Is Not Enough, Normalize More
Get Effective SQL: 61 Specific Ways to Write Better SQL, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.