1.

What do you understand by Candidate Keys in a table? Give a suitable example of Candidate Keys from a table containing some meaningful data.

Answer»

A table may have more than one such attribute/group of attributes that identifies a tuple uniquely, all such attribute(s) are known as Candidate Keys.

Table: Item

InoItemQty
I01Pen500
I02Pencil700
I04CD500
I09700
I05Eraser300
I03Duster200

In the above table Item, ItemNo can be a candidate key



Discussion

No Comment Found

Related InterviewSolutions