what is difference between candidate key and alternate key
Answers were Sorted based on User's Feedback
Answer / umer bhat
Any attribute (or set of attributes) that uniquely
identifies a row in a table is a candidate key for primary
key. Such an attribute is called a candidate key. One of
the candidate keys is chosen to be the primary key, based
on the familarity and greater usage. Any attribute that is
a candidate key for the primary key but is not the primary
key is called the Alternate key. When the key uniquely
identifies the row of the table is made than one attribute,
it is called a Composite key.
| Is This Answer Correct ? | 15 Yes | 8 No |
Answer / burhan mughal
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. 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.
| Is This Answer Correct ? | 11 Yes | 8 No |
Answer / bidut karki
Candidate key is a key that works as to uniquely define a record by combination of all attribute inside a table.
However, A candidate key that is not a primary key is called an Alternate key.
| Is This Answer Correct ? | 3 Yes | 4 No |
wats the difference between RS latch using NAND n NOR gate? which is to be preffered?
if a customer's blackberry stopped syncing their calendar wirelessly what would you do?if a customber deleted mail from his blackberry but it did delete from his mailbox how would ypu resolve this
hey guys.... My name is Bandana Thakur.Im a cse(8th sem) student.i want to make my career in php language.i want to work with google,wipro,tcs,infosys.peoples tell me that the salary package of php developer is very less n these companies do not work in php language.please tell me what i do now? should i go with the php language or make my career in another language? pls reply me in my e-mail id bandana.thakur14at@gmail.com
hi friends i am b-tech in computer science having interview of State bank of india clerk day on 30 th april. I want to know the answer of question:"you r B.tech in C.S. why do u want to become a bank clerk?" please help.Its my humble request.
0 Answers State Bank Of India SBI,
#include<stdio.h> int main() { char *ptr; char string[] = "How are you?"; ptr = string; ptr += 4; printf("%s",ptr); return 0; }
real time examples for basic concepts in oop
what are the no. of leaf nodes in a fibonacci tree ?
how to hack email id & passward
Which one is more efficient in terms of required memory space call-by-value or call-by-referance?
what is the different between view and materialized view in oracle DBA?
How do I unlock my laptop if I forgot my administrator password, a Toshiba running Windows 7?
what is the use of typedef in c language?
Civil Engineering (5086)
Mechanical Engineering (4453)
Electrical Engineering (16638)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)