Re: Table acting as a relation table

From: Lennart <erik.lennart.jonsson_at_gmail.com>
Date: Tue, 10 Apr 2007 22:53:58 +0200
Message-ID: <evgth7$k19$1@registered.motzarella.org>

Guy wrote:
[...]
> So I added a relation table:
> T_HOSPITAL_CLINIC
> HOSPITAL_CODE
> CLINIC_CODE
>
> T_HOSPITAL --------------> T_HOSPITAL_CLINIC --------------> T_CLINIC
>
> But some old modeling architect revising my model told me that it was
> not a good practive to add a table which do not have a key for each of
> its records.I would like to know why ? Any other comments
> appreciated.
> Thanks.
>

Given your design the same clinic can be related to several hospitals, is that intentional?

/Lennart Received on Tue Apr 10 2007 - 15:53:58 CDT