great for data that is mostly read intensive. not so great if you have lots of writes.

@maxk42 approach with the relationship table works well for both read and write intensive applications.