I need to create a comprehensive database for the employees in my company
Naturally I want to only create 1 database containing all the different tables needed. I want to create just 1 table with employee profile (relatively fixed data).
My question is, how do I link all the different tables? I would like to create separate tables for eg health screening (yearly occurence), accident reporting etc
Would this be achieved with different databases or can I just combine everything into 1 database?