On table it is! :-D
Thanks to all of you who helped me with my "problem".
-afan
John Meyer wrote:
> Afan Pasalic wrote:
>> hi,
>> I have a employees table (first name, last_name, address, city,
>> state, zip, phone,...).
>> though, I got a requested to add additional info about people, like
>
Afan Pasalic wrote:
hi,
I have a employees table (first name, last_name, address, city, state,
zip, phone,...).
though, I got a requested to add additional info about people, like
phone_extension, zip+4, nick, DOB... that will not be used very often.
what would be better solution:
a) add these
A wise man once taught me, "organization is the key to success".
Put all the data in the same table you have. 200k people is nothing for
mySQL to handle, and the cost of an extra JOIN is going to be a nightmare to
deal with all the time.
I thought I learned/read somewhere a long time ago that u
Unless you expect to have more than one set of "additional information" per
person, then you should add the new fields to your existing records. Don't
worry too much about space, it doesn't sound like you will be adding that
much.
I don't think that adding a new table improves normalization; in fa
