I have a employees table (first name, last_name, address, city, state,
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?