>> Like with products and categories..the product records have an FK back to >> categories table via cat_id > > This would be far too limiting for me...this forces me to have a one > to many by using a linking table I can place smoething into 2 > categories. Categories <-- Categories have products --> Products > <--products have colors --> colors > (note this is not the orginal design you had posted)...
If you know that products will always only be in one category...why add an extra table to the mix?? ....and yes...that's why I wolud use a linking table...for many-to-many relationships (products have many categories and categories have many products)...but for one-to-many it's not needed Anyways..I'm asking the designer of this data model to explain themselves...as this is not the only part of the model I found odd. Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
