The bridge tables will lead to a lot of extra joins in the rest of the application though. Like the typical case of a grid with the order items which has produc

The bridge tables will lead to a lot of extra joins in the rest of the application though. Like the typical case of a grid with the order items which has product name and category as well. Unless you mean something very different in which case some concrete examples would be nice.