-> Database Relations for e commerce product catalogue
Date: Tue, 16 Nov 2004 00:31:49 +0100
Message-ID: <cnbdmo$jc9$03$1_at_news.t-online.com>
Hi _at_ all,
I hope I spot this in the right group.
I am looking for some help to design my database. I don't know how to solve a m:n:o relation. I don't even know if the term m:n:o exists...
For example:
1.) I have a shop that has different deparments for men and women.
2.) Each department hast categories. One category could exists in one or more departments.
3.) Every category has one product brand. But a brand can exist in one or more categories in order to this in one or more departments
And one product has a brand, can exist in one or more categories and can also exist in one or more departments.
I started to create tables that collects single departments, categories and
brands.
What is the best way for the relations?
Thanks for any help in advance...
Felix