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 |
can i knw what are we supposed to read for the coming oces/dgfs 2009 exam?what kind of book are we supposed to study?
what does static variable mean in c language?
What are saw filters used for?
can you please tell me your understanding in database,what is it
write a program to accept 25 characters and at the end display the largest and smallest among them.
What are the main assumptions that we make when we model potential flow?
What is spooling and buffering?
why you are suitable to work here???? plzz give me the ans f this Q. i was told to write 200 words on the spot....
find the net id and host id of the following IPV4 117.34.3.8 and 132.57.8.6
0 Answers Green University of Bangladesh,
Who secured the first hat trick in the 20 - 20 match ? a) symond b)balaji c) muthaiya muralidharan
What is the reason of hunting of variable turbine geometry?
A rectangular sheet dimensions a x b is to be made into an open-topped box by cutting a square of side h from each corner and folding the 4 sides up. Find the value of h which allows the maximum volume of the box?