No products in the cart.

What is the basic diffrence between …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

What is the basic diffrence between primary and candidate key?
  • 1 answers

Gaurav Seth 6 years, 6 months ago

<th>BASIS FOR COMPARISON</th> <th>PRIMARY KEY</th> <th>CANDIDATE KEY</th>
Basic There can be only one primary key in any relation. There can be more than one candidate key in a relation.
NULL No attribute of a Primary key can contain NULL value. The attribute of a Candidate key can have NULL value.
Specify It is optional to specify a primary key for any relation. There can not be a relation without candidate key specified.
Feature Primary key describes the most important attribute for the relation. Candidate keys present candidates that can qualify for Primary Key.
Vice-Versa A primary key is a candidate key. But it not compulsory that each candidate key can be a primary key.
http://mycbseguide.com/examin8/

Related Questions

Types of e-commerce fraud
  • 0 answers
5 uses of mouse
  • 0 answers
Give two feature of internet
  • 0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App