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
tell me the functionality,advantages and disadvantages of student database

Develop a database broker framework to implement a persistence mechanism for the domain objects involved in the use case dealt with in Question 2.  a. Specify the attribute type

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing

What is conceptual model ? A conceptual model is a independent of both hardware and software.

What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart


Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural