195k views
4 votes
Which key retains its uniqueness even after you remove some of the fields?

The___ retains its uniqueness even after you remove some of the fields.

User GrayFox
by
7.1k points

2 Answers

3 votes

Which key retains its uniqueness even after you remove some of the fields?

The____ retains its uniqueness even after you remove some of the fields.

The answer is Super Key

A super key is any combination of keys within a table that uniquely identifies each record within that table. For example, the primary key is a subset of super keys. The difference between a candidate key and a super key is that a super key retains its uniqueness even after you remove some fields

User Tarun Bhatt
by
7.7k points
5 votes
The Unique constraint/key.

Unique constraints or keys can be used to retain the uniqueness of combinations of fields replaced as a primary key with a generated ID. They enable you enforce 1 -1 relationship. There may be one Primary Key for one table and many unique key constraints for one table.



User Calista
by
7.5k points