Hello,
I have the following tables:
CustomerPersonalDetails
ID, Name, Surname, etc.
CustomerAccountDetails
ID, UserName, Password, ApplicationDate, RegistrationDate
with single and original data,
and
CustomerEconomicOverview
ID, + Fields with Calculated Data
​Custo​merBehaviourOverview ID, + Fields with Calculated Data
with single and calculated data.
They all are connected with 1:1 relation.
I would like to ask what the suggestable practice is; to keep the data grouped and separated like above or to put them all in one table.
Also, my intention is to encrypt all original data.
Thanks in advance.