Hello,
I create a software for managing tax information. There is a personal info and the financial info that needs to be stored, and my question is whether it is a good practice to make one table with all the fields (personal information and financial information) or to make two tables, one for the personal information and another for the financial data with a one-to-one relationship.
I'm interested whether there are any rules according to data-normalization or good practices.
Thanks for your time in advance!
Christian Isberner
Software Consultant