Table acting as a relation table

From: Guy <guhar1_at_yahoo.com>
Date: 10 Apr 2007 12:41:06 -0700
Message-ID: <1176234065.967489.150710_at_s48g2000cws.googlegroups.com>

Following the recommendation of UML-2 on relation classes (I am not an ER guy), I have created a table which links each record of table A with 0..N records of table B. For example:

T_HOSPITAL --------------> T_CLINIC

                            0..N

I needed to add a link table which will store the clinics of an hospital, but I cannot change the structure of neither tables because the legacy model is too fragile, and hard coded evewhere in my applications.

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. Received on Tue Apr 10 2007 - 21:41:06 CEST