1.

i)Whichofthefollowingcannot be used to uniquely identify a tuple in a relation?a) Super key (b) Primary key (c) Candidate key (d) Foreign key

Answer»

A superkey is a set of attributes within a table whose values can be used to uniquely identify a tuple.A candidate key is a minimal set of attributes necessary to identify a tuple; this is also called a minimal superkeyA primary key is a field in a table which uniquely identifies each record/tuple in a database table.

Therefore, foreign key can not be used to uniquely identify tuple in a relation.

(d) is correct option



Discussion

No Comment Found