Re: -> Database Relations for e commerce product catalogue

"Felix Becker" <dines_at_gmx.net> wrote in message news: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
>
>

Check out www.databaseanswers.com Received on Tue Nov 16 2004 - 09:37:23 CET