Home > IT Answers > Database > 1:1 Modeling Inheritance 1:1
Wolfrvr
5 pts.
 1:1 Modeling Inheritance 1:1
Database, Database design, Modeling Inheritance
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 Organization Employer Employment 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?

Software/Hardware used:
ASKED: December 12, 2008  6:22 PM
UPDATED: December 12, 2008  6:40 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _