If different colors would go into different categories (seems a bit odd but is bussiness could dictate this) how would you approach it differently than what you originally presented? Example: A dress comes in a variety of colors Red, Pastel Blue, Green, Yellow, Black. The dress is a Spring Dress. The Pastel Blue would make a great easter Clothing option Black wouldn't be very Easter like. At this point how do you design your model? When you design a schema you can not only look at what is happening but what might happen. OUr main bussiness objective where I work is reporting so theres not a lot fo speculation as to what might happen...designing schema is simple and straight foreward...thats not always the case though, ecspecialy in ecommerce (which obviously is what I am using as a backing for this...take it out of the cantext and good chance I have no foot to stand on :) )
Adam H On 5/9/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > Yeah Kerry...it's a one-to-one on category so hiking boots only in one > category...but thanks ;-) > > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206094 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
