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
- 189134 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
What is a database lookup?
How do you pass parameter in stored procedure?
What is the Lock Based Protocol used for?
What are the disadvantages of views in a database?
Explain normalization in one line?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What is database schema name?
How to implement database security?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
Explain inner and outer joins with examples.
What is database server and how it works?
What is the relationship that exists inside in E-R diagram?
What is database client?
How many types of locks are present in a database?
