Number of foreign keys
From: Vinodh Kumar P <vinodh_at_here.com>
Date: Thu, 2 Dec 2004 13:07:22 +0530
Message-ID: <comgnk$au1$1_at_news.mch.sbs.de>
I understand the number of foreign keys allowed is restricted by the DBMS I use.
In a general relational schema design perspective how many foreign keys a table shall have?
If I have large number of foreign keys what anamolies it will lead to? Is this crucial to identify all the foriegn key relationships for a table?
Date: Thu, 2 Dec 2004 13:07:22 +0530
Message-ID: <comgnk$au1$1_at_news.mch.sbs.de>
I understand the number of foreign keys allowed is restricted by the DBMS I use.
In a general relational schema design perspective how many foreign keys a table shall have?
If I have large number of foreign keys what anamolies it will lead to? Is this crucial to identify all the foriegn key relationships for a table?
Vinodh Received on Thu Dec 02 2004 - 08:37:22 CET