what is candidate key & primary key,different b/t the two?

Answer Posted / parijatha

there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between database and schema?

558


Define and explain about progress?

600


What do you understand by query optimization?

590


how to retrive a data From database into the grid view..?

570


Why do we study dbms?

584






How do you rename a database?

545


Does google have a database program?

581


Is declare cursor executable?

607


How is data stored in a relational database?

597


how to solve cardinality in dbms...many to many ralationships

1352


How do I create a database in open office?

592


What is the most used database?

624


Why do we need to use a database?

586


Can you explain insert, update and delete query?

627


Explain a join between tables?

632