A
ABC123
What are people's opinions of splitting up detail as much as possible into
more tables?
I am creating a table for employees. I was planning on putting all contact
details into one table, however I am now thinking of doing the following:-
Table1
PKemployeeID
Name
Surname
Table 2
PKemployeeID
FKcontactID
Address
City
Telephone
Email
I will never need to search on people's addresses etc, so would it be best
just to put it all in one?
more tables?
I am creating a table for employees. I was planning on putting all contact
details into one table, however I am now thinking of doing the following:-
Table1
PKemployeeID
Name
Surname
Table 2
PKemployeeID
FKcontactID
Address
City
Telephone
I will never need to search on people's addresses etc, so would it be best
just to put it all in one?