Refactoring Databases - Evolutionary Database Design

Replace One-To-Many With Associative Table

Replace a one-to-many association between two tables with an associative table.



Example

Replace One-To-Many With Associative Table Example

For more information see page 130 of Database Refactoring