Compound Keys

From: <matt222_at_my-dejanews.com>
Date: Wed, 03 Mar 1999 19:52:41 GMT
Message-ID: <7bk3u6$l0g$1@nnrp1.dejanews.com>

I have four tables.

Table #1 MODEL
Table #2 PART
TAble #3 SERIAL
Table #4 ORDER
Table #1 MODEL contains the PK= Model_Num

(there is a one to many join from MODEL to PART)
*one model can have many part numbers
Table #2 PART contains the PK Part_Num plus the FK (primary id) Model_Num together as a composite/compound unique primary key

(there is a one to many join between MODEL and SERIAL)
*each model number can have many serial numbers

Table #3 SERIAL contains the PK Serial_Num plus the FK Model_Num together as a composite/compund unique primary key

(there are two joins - there is a one to many join between PART to Orders and

a one to many join between Serial to Orders)

Table #4 ORDER has a PK ORD_Number. There are 2 migrated FK's from Table PART with values PART.PART_Num and PART.Model_Num as well as another 2 migrated FK's from table SERIAL with values SERIAL.Serial_Num and SERIAL.Model_Num.

THE SITUATION: -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 13:52:41 CST