Define candidate key, alternate key, composite key?
Answer Posted / kumaresan chandran
A candidate key is one that can identify each row
of a table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more
columns is called composite key.
Is This Answer Correct ? | 89 Yes | 27 No |
Post New Answer View All Answers
What are the three basic rules which are to be followed for the relational model of the database?
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 use online Backups?
What is a database development?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain about the storage and physical database design?
Explain about the relational database?
What are the key features of dbms?
What are the types of database model?
What is the database development process?
Explain about a primary key?
Explain about network model?
I have a few records all are same structures data, I want to store data in multiple targets how
What is normalization? Explain different levels of normalization?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS