what is difference between candidate key and alternate key
Answer Posted / 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 |
Post New Answer View All Answers
i have passed my gRaduation in BCA and now im looking for post graduation from Germany, i haver passed my ielts wth 6 band, nw plz tell me some question that wll ambessay ask
please provide me the type of questions or question pattern of bally.
can u tell me placement peoceduers and placemnt format of hpcl.
WAP in Java to print the format AMIT M I T
Can you delink a payer from a bill to sold to ship to and then create a new payer on the existing bill to sold to ship to, this is where a pub or club changes licencees and we want to icolate the debt from the old owner but keep the sales history on the ship to/sold to
what is compiler
assemblies in .net
Dear frds In my office we are using chiller . in that chiller inlet and outlet water diff. is 2.5 decgree always. if i intduce the cooling tower can i get good result in chiller Inlet water. reply plz.
hi this is amit..please help me to out this problem Objective 8: Create Resources (Function libraries) Requirements: Create a new order with the Flight Reservation application. 33. Use the script created above. 34. Write a function using VBScript that will take a date as an input and add 10 to it. i.e. if the date is passed as “15/08/2008” then after adding 10 it should become as “25/08/2008” 35. Use this function to parameterize the step used to enter “Date of Flight” 36. Run the pack thanx & regards
A short CI column of hollow circular section has projecting bracket carrying a load of 10 tonnes. The load line is off the column by 20cm. The external diameter of the column is 350mm and thickness of metal is 25 mm. Find the maximum stress intensity in the section.
I am helping a friend to design a concert hall. No need for super architectural show off. Just a rectangular box. Knowing that in my country constructions are done with reinforced concrete and concrete blocks and that the hall's dimensions are, length: 75 meters, width: 32m height: 9m, and that there should not be any columns inside, what would be the size of the columns, beams and roof slab ?
what is the quantity of cement and sand in 1 sq.m (mortar ratio ) a, 1:4 b, 1:3 c, 1:6
What are special features of Silk Test ? In what way it is advanced than QTP?
why IT?
Prove that in a self-complementing code the sum of the weights must be 9?