Someone recently asked this question:
There are two tables: Deal and DealCategories. One deal can have many deal categories.
So the proper way should be to make a table called DealCategories with the following structure:
DealCategoryId (PK) DealId (FK) DealCategoryId (FK)
Can someone explain why DealCategories table has