>Anyways..I'm asking the designer >not the only part of the model I found odd
im gonna guess they cut and pasted from another project.... -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 18:50 To: CF-Talk Subject: Re: odd data model >> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206097 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
