I am working on a database to store employment history. A person can be employed by an organization or another person.
I created the following tables:
Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with Employment.
Is this an acceptable way to model the requirement?