No products in the cart.

What is the basic diffrence between …

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

What is the basic diffrence between primary and candidate key?

Posted by B.K Kirti 5 years, 2 months ago

CBSE > Class 10 > Computer Applications (165)

1 answers

Gaurav Seth 5 years, 2 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.

1Thank You

ANSWER

Related Questions

The protocol that is used to send E mail is.............?

Posted by Kishan Mishra 1 month ago

CBSE > Class 10 > Computer Applications (165)

0 answers

which type of pages gets created fro DHTML?

Posted by Balaraj Jayasankar 2 months, 4 weeks ago

CBSE > Class 10 > Computer Applications (165)

2 answers

Communication skills are very important for any business explain any tao element of a communication

Posted by Riya R 3 months ago

CBSE > Class 10 > Computer Applications (165)

0 answers

difference between

and tag ?

Posted by Ankit Parihar 3 months, 2 weeks ago

CBSE > Class 10 > Computer Applications (165)

1 answers

difference between

and tag

Posted by Ankit Parihar 3 months, 2 weeks ago

CBSE > Class 10 > Computer Applications (165)

1 answers

Different between internet and www

Posted by Shashi Kiran 1 month, 1 week ago

CBSE > Class 10 > Computer Applications (165)

1 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Harsh . 1 month ago

CBSE > Class 10 > Computer Applications (165)

1 answers

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Rohit Yadav 1 week, 1 day ago

CBSE > Class 10 > Computer Applications (165)