What is the function of the alternate key?

An alternate key is a set of one or more attributes in a database that can uniquely identify a record, similar to a primary key, but is not designated as the primary key. Its primary function is to provide additional means of accessing data efficiently, ensuring that each record remains unique. Alternate keys enhance data integrity and flexibility in querying the database. They are particularly useful for enforcing business rules and improving search capabilities.