Fewpal
0 votes
137 views
in Computer by (47.7k points)
closed by

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

1 Answer

+1 vote
by (50.2k points)
selected by
 
Best 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

Related questions

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...