Chapter 14: Table Design for Many-to-Many Relationships — Junction Tables, Self-Reference, Tags, and RBAC
This chapter covers implementing a many-to-many relationship with a junction table, using many-to-many with attributes (products and suppliers), self-referencing many-to-many (follows), a tag system, and RBAC (role-based access control) as examples, along with modern alternatives to trigger-based aggregation (application layer / materialized views / Redis).