Primary and foreign key, Database Management System

Primary Key

The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candidate keys, if any, are called as alternate keys.

Foreign Keys

Let us first tell you the basic definition of foreign key.

Let R2 be a relation, then a foreign key in R2 is a subset of the set of attributes of R2, such that:

1.   There be a relation R1 (R1 and R2 not essentially distinct) with a candidate key, and

2.   For all time, every value of a foreign key in the present state or instance of R2 is identical to the value of Candidate Key in a few tuple in the present state of R1.

Posted Date: 3/6/2013 6:31:03 AM | Location : United States







Related Discussions:- Primary and foreign key, Assignment Help, Ask Question on Primary and foreign key, Get Answer, Expert's Help, Primary and foreign key Discussions

Write discussion on Primary and foreign key
Your posts are moderated
Related Questions
List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to


What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Explain the challenges before an E-business management.

What is the max. no. Of structures that can be included in a table or structure. Nine.

A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. In par

What is the purpose of tables, private synonyms and public synonyms? If there are multiple objects of similar name on an Oracle database, that order are they accessed in? The r


Use Delegation to Share Implementation The delegation " Delegation comprises of catching an operation on one object and sending it to other object which is part, or related to