What is the disavantage of having big tables , instead of having more than one small tables .
I have an employee table and i have included home address details and residence address details in the emp details . which is the best design
1.have all the detaiks in one table
2.Have one emp details and one address details tables
3..Have one emp details and one Personal address tables and one Office Address
if any other option exists please let me know