Re: Many to many
From: David Cressey <info_at_dcressey.com>
Date: Thu, 7 Dec 2000 10:44:15 -0500
Message-ID: <3a2fb065_at_news2.starnetinc.com>
Date: Thu, 7 Dec 2000 10:44:15 -0500
Message-ID: <3a2fb065_at_news2.starnetinc.com>
Arne,
Stop arguing with yourself, you're both right!
A composite primary key can have a foreign key as one of its components.
The third table should generally have a primary key declared as the two foreign keys, for the sake of the integrity of this table. Then, each of the keys should be declared as a foreign key referring to the appropriate table. That protects referential integrity.
Arne Jonsson wrote in message <3a2bffba.52190770_at_news1.telia.com>...
>For about two years I´ve been living happily in the belief that if you
Received on Thu Dec 07 2000 - 16:44:15 CET