Its normailsed if you have different colors in different categories....which I make the assumption that would be the case. I don't know that I would design it this way but it makes enough sense to me...There are different norilization patterns and this seems to match one of them pretty closely..its just not may not be 3rd nromal form...
Adam H On 5/9/05, James Holmes <[EMAIL PROTECTED]> wrote: > I agree - it doesn't seem normalised (it seems to repeat a lot of info for > each colour). > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 10 May 2005 1:06 > To: CF-Talk > Subject: Re: odd data model > > > This does not seem too odd to me what you discribe, if I understand, > > is just a normalized Schema it seams....Products, Categories, and > > Colors then a linking table that dictates what products/colors are in > > what category... > > Adam...the example was simple and has nothing to do with products ;-) > > Typically (using prod/cat/colour example) you'd have 4 tables (product, > category, colour, product_colour) and the products table would be joined to > the category table via cat_id (one to one) and to the colour table via the > product_colour table which contains colour_id and product_id (one to many). > > What I've been shown is a central table that has product_id, cat_id, > colour_id and the cat_id would be duplicated for each colour_id. > > I've never seen it done this way...seems clumsy > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:206088 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
