Define candidate key, alternate key, composite key?
Answer Posted / sanjay p sonar
Candidate key:-A candidate key is unique. We may say that
candidate key is another name of primary key. We can have
more than one candidate key. From which we have to choose
one as a primary key.
Alternate key:-The Candidate key other than primary key is
Alternate key. We can have more than one Alternate keys.
Composite key:- When we combine more than 1 column by key
then that key is called Composite key
Clustered Key:- When we combine more than 1 column to form
Primary key then it will become Cluster key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are data modelling techniques?
How long can an error message be in raiseerror function?
What is data modeling with example?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How to customize error conditions.
Explain about a primary key?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What are the main phases of database development?
Explain the process of the user request and data generating?
What are the three basic rules which are to be followed for the relational model of the database?
What is dbms explain in brief?
Who are naive users?
What is a database development?
fact table and dimension table containg one to many relationship or many to one relastionship
What are the types of database model?