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 |
Write the fetch cycle and execute cycle for following instructions:JMPNZ (jump to the given address if the accumulator not equal to zero) RET(return from a subroutine) ADB (add the contents of register B to the accumulator and save result in the accumulator).
how to make resume and what should I include in it?
hi,i just want to know the best institute to learn oracle in bangalore because i am doing my BE there?
What is the full forms SDDC,TOR,DLRO,PPP,USW,AWWA,CMOS,SVI,
In an entity relationship, y is dominant entity and x is a subordinate entity. Then which of the following is/are correct 1. operationally, if y is deleted, so is x 2. x is existence dependent on y 3. operationally, x is deleted on y 4. operationally, x is deleted, y remains the same
Are the JVM for C & JVM for JAVA are different?
Explain work?
is there eligible for computer science engg students to write exams and how much percentage we want to attempt exam based on degree
to which generation of prog. languages does ai prog languages belong
What is the meaning of "co relation" and what is the value of "co relation" in the performance testing environment.
Q1. A. Discuss the various types of variables. B. How to control the file? Q2. A. How the image application? B. Write short notes on trees structures work. Q3. A. How to load and unload child forms. B. When should we use recursive programming Q4. A. Write short notes on “The ole control’s shortcut menu” B. How to test the AX stat class Q5. A. How to use advanced data-bound controls. B. Write notes on manipulating the recordset object Q6. A. What is script control? B. How to down load image properties. C. What is meant by building a recordset.
what is defect tracking in sotware testing
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)