168k views
3 votes
3) Which one of the following is a set of one or more attributes, taken col

identify a record?
A Super key
B. Candidate key
Sub key
C.
D. Foreign key
ic.
nttributes of any tuple in

User Onoma
by
7.3k points

1 Answer

3 votes

Final answer:

A Super key is a set of one or more attributes that can uniquely identify a record in a relational database table.

Step-by-step explanation:

A Super key is a set of one or more attributes that can uniquely identify a record in a relational database table. It is a combination of attributes that can guarantee the uniqueness of a tuple in a table.

A Candidate key is a subset of a super key that does not contain any unnecessary attributes. It is the minimal set of attributes from a super key that can uniquely identify a tuple in a table.

A Foreign key is an attribute or a set of attributes in a table that refers to the primary key of another table. It establishes a relationship between two tables by enforcing referential integrity.

In this case, the correct answer is A) Super key.

User Salman Siddiqui
by
7.0k points