January 7th, 2014, 07:05 AM
Need advice about creating db tables
I'm creating a new DB for a project. I have a table for "Domains", now each Domain can have several Categories (Sports, Gambling, etc).
I was think of creating a table for Categories but I am not sure how to link them to the Domains. I mean if a Domain have multiple categories I can't just add a column in the Domains table and because a Category can be applied to multiple Domain there's no reason to put a Domain column in the Category table. So what, do I create a CategoryPerDomain table ? It seems a bit redundant, no ?
Any advice ??
January 7th, 2014, 09:13 AM
January 7th, 2014, 09:34 AM
Thanks for your reply and the links, it helped me clarify things.