Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Superkey vs. Candidate key

What difference between Super and Candidate key in ERDB?

like image 978
Stan Kurilin Avatar asked Jun 21 '10 19:06

Stan Kurilin


1 Answers

A superkey is a set of columns that uniquely identifies a row. A Candidate key would be a MINIMAL set of columns that uniquely identifies a row. So essentially a Superkey is a Candidate key with extra unnecessary columns in it.

like image 76
Eric Petroelje Avatar answered Nov 15 '22 19:11

Eric Petroelje