I am making a database and currently trying to normalise it to bcnf, all my other tables i believe i have got correct and work in the best way. However i was wondering whether or not for my Employee table if using bcnf it is wise to try and split up the table?
The table consists of attributes suich as employee id, fname, sname, sex, houseno, street name etc etc and stuff like phone number. Looking at it i feel i maybe could split it up, but im not sure if maybe it would be best to keep it all in one table as it is mainly all contact information as there isnt really anything that applies to projects an employee may be assigned to!
any opinions would be helpful