Re: Question about modeling
Date: Thu, 27 Jan 2005 14:55:02 GMT
Message-ID: <ah7Kd.2146$fT4.291_at_trnddc09>
"Alexandr Savinov" <savinov_at_ais.fhg.de> wrote in message
news:41f8c5d8$1_at_news.fhg.de...
> Once for each Contrat there is only one Client then you might
> store a reference to this client directly in Contract:
>
> CONTRACT (cn_id, cl_id, cn_details)
>
[snip]
> DEPARTMENTS (dp_id, dp_otherStuff)
>
> Now departments do not reference directly any client.
> Instead, departments are related to clients only indirectly via
> DEPTS_CONTRACT_LINK and then CONTRACT.
>
> alex
>
Verty true. The question in this case (to the OP) is whether departments
can ever be assigned to a client without a specific contract existing at the
time of assignment. In other words, which comes first? -- the contract or
the department, or is it arbitrary? As usual, subtle differences can change
the model in major ways.
Regards,
- Dan