Re: Question about modeling
From: David Cressey <david.cressey_at_earthlink.net>
Date: Thu, 27 Jan 2005 21:57:05 GMT
Message-ID: <RsdKd.659$Yd7.176_at_newsread2.news.atl.earthlink.net>
Date: Thu, 27 Jan 2005 21:57:05 GMT
Message-ID: <RsdKd.659$Yd7.176_at_newsread2.news.atl.earthlink.net>
Mathieu,
Let me see if I can express your requirements in the simplest terms.
A client can have contracts.
Is this an accurate summary what you are trying to model?
A client can have departments.
A contract can be divided into portions.
A department can have a portion of a contract.
Two departments can have different portions of the same contract if and only
if the two departments belong to the same client.