Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116004 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
What is nonclustered index on computed columns?
What are the advantages of sql azure?
Explain what is the purpose of sql profiler in sql server?
How to provide column names in insert statements in ms sql server?
What are the steps to process a single select statement?
Can you explain full-text query in sql server?
How to retrieve error messages using odbc_errormsg()?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What are user-defined functions (udfs) in sql server?
What is the difference between delete and truncate statements?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is 3nf normalization form?
How do you clear a log file?
What are the different types of lock modes in sql server 2000?
What is indexing a document?
