ERD for time-based relationships

From: Jay <googlegroups_at_jayritchie.com>
Date: 8 Aug 2003 11:03:50 -0700
Message-ID: <dccfa262.0308081003.73c0a954_at_posting.google.com>

I'd like to know if anyone can recommend how to best persist relationships between 2 entities that only exist for a period of time. For example, there is a relationship between a master account and a sub-account. I want to know for any date, what the sub-accounts exist for a specific master account.

Other requirements:
-Prefer a design that can persist a relationship between any 2
entities, i.e., one relationship table for all relationships in a db.
-Enforce multiplicity constraints

Thanks.

Jay A. Ritchie Received on Fri Aug 08 2003 - 20:03:50 CEST