-> Database Relations for e commerce product catalogue

Hi @ 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 Received on Mon Nov 15 2004 - 17:31:49 CST