Greetings
I have the following question. I'm designing a new database for a human resource application. I will construct a table for employee information is it good to separate the employee information to 2 tables one for personal information and the other one for work data such as the salary, type of contract, working shift etc.? or it is better to but all the data within one table?
It depends on the duration,data is being updates and relationship between them.
As for your case,user personal information will not change a lot,but work data might change,so it is better to seperate the two data in different table and maintain one to one mapping between two tables.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.