You really wouldn't want to break them into individual columns, because
then if you needed another value you would have to change your table to
accomodate it. You want to add a row for new values. As Bryan says you
need a many to many table to join them. For example, a car could have
many colors and a color could be used for many cars so the following:
Model_Table Model_Color_Table Color_Table
Model ID ModelID ColorID ID Color
Ford 1 1 1 1 Blue
1 3 2 Green
3 Red
Would show we have a blue and a red ford. Using this method you
can add as many models or colors as desired and simply join them
using the Model_Color_table.
> Can you tell me what developers generally use as alternatives? Should
> I break the values into individual columns? Thanks for your advice!
>
-chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:203591
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
