Re: -> Database Relations for e commerce product catalogue

This should represent your relationships as given.

Tables with keys

Department__________

depID                     PK

Brand_______________
brandID                   PK

Catagory____________
catID                      PK
depID                 PKFK
brandID                   FK

Product_____________
prodID                    PK
brandID              PKFK

ProductCatagory______
prodID                PKFK
brandID              PKFK
catID                  PKFK
depID                 PKFK

However at first glance at your discription you need to give more thought to what those relationships actually are. They do not sound real world. How can a catagory only have one brand in real world setting? this would mean that your store is limited to only Levi Jeans and can not have Eddie Baur Jeans. This needs more thought before implementation. I do not think you have grasped the ACTUAL real world relationships that the db is supposed to model. Received on Tue Nov 16 2004 - 15:59:26 CET