Database Normalisation Questions
Candidate keys in database normalization refer to the attributes or combination of attributes that can uniquely identify each tuple or row in a relation or table. These keys are potential candidates for primary keys and are used to ensure data integrity and eliminate redundancy in a database. In other words, candidate keys are the minimal set of attributes that can uniquely identify a tuple in a relation.