Simple question on data design...
Date: Wed, 7 Nov 2001 21:22:07 -0800
Message-ID: <6TmG7.256$UW5.202030_at_news.uswest.net>
Hello, group.
Consider tables with columns that contain data from a limited, pre-set list or domain, such as:
tblAddresses (AddressID, ClientID, Street, City, State, Zip, AddressType)
where the attribute AddressType could be one of the following:
Primary
Billing
Shipping
Location
(disregarding whether this is a good model or not) ...one could store the data as shown above, or each value could be represented by a single letter. The single character value could save space, but requires more work when displaying the data in a meaningful way (by substituting the word represented)... Other similar scenarios would include attributes like ShippingMethod, PaymentType, Gender, etc...
Is there any logic that suggests one approach over the other?
many thanks for any suggestions,
Zigler Received on Thu Nov 08 2001 - 06:22:07 CET