Candidate keys, Database Management System

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even after removing it from the key, create the remaining attributes still has the properties of a key.

The following properties must be satisfied by the candidate keys:

  • A candidate key's value must exist. It cannot be null. (This is also known as entity integrity rule)
  • A candidate key has to be unique.
  • A candidate key is a smallest set of attributes.
  • The value of a candidate key has to be stable. Its value cannot change outside the control of the system.

A relation can have more than single candidate keys and one of them can be chosen as a primary key.

For instance, in the relation PERSON the two likely candidate keys are PERSON- ID and NAME (assuming unique names in the table). PERSON-ID may be taken as the primary key.

Posted Date: 3/6/2013 5:24:18 AM | Location : United States







Related Discussions:- Candidate keys, Assignment Help, Ask Question on Candidate keys, Get Answer, Expert's Help, Candidate keys Discussions

Write discussion on Candidate keys
Your posts are moderated
Related Questions
A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe

what is RDBMS? how it works? good example.

What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);

Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

Preliminary entities and attributes of human resourse management database management system

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La

Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the