Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Number of foreign keys

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@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 - 01:37:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US