Sarthaks APP
0 votes
57.2k views
in Computer by (48.2k 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.8k 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

by (33 points)
if itemno 109 has an item "ruler", then what are the candidate keys?
Sarthaks APP

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

...