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 |
i need the placement paper of ford IT service...
what are the artifacts in coding phase in SDLC????
why need of new operator in java why not in c++
What is the difference between wimdow Nt, 2000 amd 2003 server ?
what is the best thing in engineering?
main() { int a=10,b; b=a>=5?100:200; printf("%d\n",b); }
Please mail me the sample papers of PNB for the post Dy. Manager.
explain overloaded constrator © constractor
how to store the vacuum in tank? its possible? what are the units for measure the vacuum ?
Some question are asked from computers also. How we calculate sum in Excel? can we find cube root in Excel if yes , how? If i want to send excel sheet to 10 different person, how i can send it ( don`t tell me by mailing) condition given by interviewer.If A=.03rs(tsqr), value of r increase by 50%, s by 30% & t decrease by 20%. find value of A. If two coins having dia 25 & 16 they are rotate in their axis , Coin having dia 25 reach a point at x per sec, in how many min coin having dia 16 reach that place, Both are rotating in same direction.
what are the various login options used in loadrunner tool to make a application performance testing
what are the main points to be included in our introduction when asked in hr...??
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
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)