Re: Table acting as a relation table
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 10 Apr 2007 22:39:08 GMT
Message-ID: <gmUSh.23133$PV3.228663_at_ursa-nb00s0.nbnet.nb.ca>
Date: Tue, 10 Apr 2007 22:39:08 GMT
Message-ID: <gmUSh.23133$PV3.228663_at_ursa-nb00s0.nbnet.nb.ca>
Guy wrote:
> I am going to rephrase my question:
>
> T_HOSPITAL <-------------- T_HOSPITAL_CLINIC <-------------> T_CLINIC
> HOSP_CODE HOSP_CODE
> CLINIC_CODE
> CLINIC_CODE
>
> With my asssociation table I can define which clinic belongs to which
> hospital. Someone told me that such table cannot have the only two
> field HOSP_CODE, CLINIC_CODE, but some other "key" field should be
> there. Quote "a table with no key to identify each row should not be
> modeled".
Oh, one of THOSE people.
> Obviously my table will work as is. Is there however a rule I am
> enfringing ?
No, not really. Received on Wed Apr 11 2007 - 00:39:08 CEST