What is candidate key, Database Management System

What is Candidate Key

Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can never have NULL values. There can be more than one super key or candidate key in a table e.g. within a STUDENT table Roll and Mobile No. can both serve to uniquely recognize a student.

 

Posted Date: 7/26/2013 6:06:48 AM | Location : United States







Related Discussions:- What is candidate key, Assignment Help, Ask Question on What is candidate key, Get Answer, Expert's Help, What is candidate key Discussions

Write discussion on What is candidate key
Your posts are moderated
Related Questions
Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

Let us first look into some of the important features of ER model. Entity relationship model is a high-level conceptual data model. It permits us to define the data invo


Write short notes on domain relational calculus   The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole

a method named WonGame that checks each letter in the word is matched by its label

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object