Check out these articles from part 1 of the Databases & SQL e-book, now available to all subscribers:
Introduction to Databases
- Designing Databases
- Handling Many-To-Many Relationships
- Managing Complexity, Rule 1: Eliminate Repeating Fields
- Managing Complexity, Rule 2: Eliminate Redundant Data
- Managing Complexity, Rule 3: Eliminate Columns That Don’t Belong
- Managing Complexity, Rule 4: Isolate Independent Multiple Relationships
- Managing Complexity, Rule 5: Isolate Semantically Related Multiple Relationships
- Displaying Normalized Data
- Displaying Many-To-Many Relationships
- True Confessions: A Tale of Two Users