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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!