A composite key is a combination of two or more columns in a database table that together uniquely identify a row, ensuring data integrity when no single column can serve this purpose alone. It is essential in relational databases where complex relationships between tables require unique identification through multiple attributes.