http://www.perlmonks.org?node_id=317457


in reply to Class::DBI has_many

Now good database design, has taught me that when one has a 1:N relationship, one should construct a new table to hold that relationship.
This is more than third normal form requires, which is usually sufficient for most purposes. If you're striving for fourth normal form (or the lofty and mostly-academic fifth), your strategy might be appropriate.