Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115976 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / shruti singh
Any attribute that is uniquely identify a row in a table is
candidate key for the table. We select one of the candidate
key as Primary key. All candidate keys which are not chosen
as "primary key" are Alternate keys. The key which uniquely
identify the rows of the table and which is made up of
more than one attribute is called Composite key.
As for Example:In a class we have to select Class Monitor.
So A, B,C and D stand for that post. So A,B,C and D are
candidate for monitor so these are candidate key. We select
B as monitor so B is primary key and A,C and D can be
monitor but not selected as a monitor so they are
alternative choise. So A,C and D are alternate key.
When two students of class work together in a project than
they are composite key for the class.
I TRIED TO EXPLAIN THESE KEY, IF YOU LIKE PLEASE DO
RESPONSE. iF YOU LIKE TO ASK ANY OTHRE QUE RELATED TO SQL
SERVER YOU CAN..
| Is This Answer Correct ? | 541 Yes | 28 No |
Post New Answer View All Answers
Explain transaction server explicit transaction?
Do you know what is xpath?
How to identify current user in ssrs report?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Can you index views?
How can you tell if a database object is invalid?
What are the advantages of stored procedure in sql server?
How each E-R model constructs can be mapped to the relational model?
What is read committed?
Mention the command used to rename the database.
What is the use of keyword with encryption. Create a store procedure with encryption?
Does sql server use t sql?
What is the sql profiler?
Ways to improve the performance of a SQL Azure Database?
What is difference in performance between insert top (n) into table and using top with insert?
