|
|
Posted by Geoff Berrow on 06/05/07 06:47
Message-ID: <1181019367.152432.299980@m36g2000hse.googlegroups.com> from
MadDiver contained the following:
>I need to create an application that handles several product types/
>categories. Each product type can have totally different fields to
>describe it. For instance a car would have Year, Make, Model, and
>Miles, whereas a house would have Year, Address, SQ Feet, Amenities,
>etc.
It sounds like you are going to need a separate table for each type of
product. The downside of this is that you would be letting the client
design the database and they could include non-key dependent attributes
eg
House
Year, Address, SQ Feet, Amenities, water co, water co tel, water co
address
Furthermore they would probably assign incorrect data types.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Navigation:
[Reply to this message]
|