Super Key vs Candidate Key: Key Differences Every Database Designer Must Know
Super Key is any set of one or more columns whose combined values are guaranteed to be unique in a table; Candidate Key is a minimal Super Key—no subset of its columns can also guarantee uniqueness. Teams argue because “unique” sounds simple until they face 30 columns and performance budgets. Designers keep adding attributes to…