Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 185989 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mansi valani
A Foreign Key is a field in a relational table that matches
a candidate key of another table. The foreign key can be
used to cross-reference tables.
The foreign key identifies a column or set of columns in one
(referencing) table that refers to a column or set of
columns in another (referenced) table. The columns in the
referencing table must reference the columns of the primary
key or other superkey in the referenced table. The values in
one row of the referencing columns must occur in a single
row in the referenced table. Thus, a row in the referencing
table cannot contain values that don't exist in the
referenced table (except potentially NULL). This way
references can be made to link information together and it
is an essential part of database normalization. Multiple
rows in the referencing table may refer to the same row in
the referenced table. Most of the time, it reflects the one
(parent table or referenced table) to many (child table, or
referencing table) relationship.
The referencing and referenced table may be the same table,
i.e. the foreign key refers back to the same table. Such a
foreign key is known in SQL:2003 as a self-referencing or
recursive foreign key.
A table may have multiple foreign keys, and each foreign key
can have a different referenced table. Each foreign key is
enforced independently by the database system. Therefore,
cascading relationships between tables can be established
using foreign keys.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between delete and truncate table?
What is a database example?
What is the difference between data source and database?
List various types of log-based recovery in DBMS.
If the master device is full, how do I make the master database bigger?
What is relational database with example?
how can you perform lookup range in lookup stage expalin in detail?
What is a database string?
List some advantages of dbms.
What is database server and how it works?
issues involved in modeling and building data werahouses
What does new grouping sets enables you to do?
What is the advantage of varchar2 over char?
What is the database url?
Under which circumstance should you create an index on a table?
