-none- 2007-10-05 - By Afan Pasalic
Back
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 columns to employees table
b) create separate table employees_addition_info with these fields and
store info if any (with employee_id of course)
one friend of mine suggest me to keep all data in one table since the
"empty" fields will be NULL and there will not be a lot of wasted
space. specially because I'll never have more than 200K records (right
now I have about 50K records). and "normalization" will not improve a lot?
any suggestions?
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
