I would like to ask if I'm doing this right since it's my first time creating a database model.
Basically what I'm trying do build is an Employee Information model where:
- An employee can have multiple addresses but only one can be tagged as the permanent address
- An employee can have multiple positions but only one can be tagged as the current position. Same for the employee department
- The reason I choose one-to-many relationships on the position and department is to track its histories
- An employee can have multiple dependents.
Here's an example of my initial schema
I would appreciate your feedback if I'm doing it right or if you can help me design it in a much better way.