What is candidate key in DBMS?

What is Candidate Key in DBMS? A Candidate Key in DBMS is a minimal set of columns/attributes that can be used to uniquely identify a single/every tuple or row in a relation. Candidate Keys are determined during database design based on the underlying business rules of the database. After finding all possible candidate keys in a relation.DBA choose one key as a primary key. Consider the following relation in the context of a business firm: candidate key  E...
Read More