just a thought, i know the products/categories/colours is just an example but, perhaps the db structure makes sense if you have something like this:
black hiking boot in the outdoor category brown hiking boot in the outdoor category black hiking boot in the casual category brown hiking boot in the casual category although some real data might change my mind about wether or not the data structure makes sense.... -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 18:12 To: CF-Talk Subject: RE: odd data model 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:206089 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
