From the perspective of the code of the app we're developing around this database, this this doesn't seem to give any benefit. It's actually easier to have a pivot table because the framework we're using makes many-to-many relations trivial. Is there more to it? Is there a performance benefit to doing it this way? I'll be the first to admit SQL in general is not one of my stronger points, so am I missing something?