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
The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex

what is bogus empowerment. And what is genuine empowerment

Northwind Pty Ltd sells a variety of food products throughout the world.  They want to use the reporting features of SAP's Business Information Warehouse to better understand their

How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

Write the C++ program having class name studentinfo, that is used to store the VU student information: This class should store your VUID, campus id, name and father name in the fol

What are the several forms of identity? a) Value b) Name c) Built-in

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)