category table 4 products, events, etc??

[Anon]

Let's say i have "products", "events" and "news" tables -- now I want to be able to categorize the data in each of these tables. Would it make sence to have 1 categories table for each of these?

Or should i have an eventcategories table, and a productcategories table?

[Anon]

You can do it either way it just depends on how you are going to get the data into the tables, and who is doing the work.

If you build 1 table that holds all of your categories are you sure that someone entering the data won't put a news story into a product category? If you have to restrict the categories by what table they can affect then it'd probably be easier to have multiple tables.