A record in the database is known as a tuple. A record that is identified by a combination of two fields has a composite key.
When a record is identified by a combination of two fields, it is called a composite key. This means that the combination of both fields must be unique in the database to identify a specific record.
secondary key
foreign key
foreign key
foreign key
foreign key
foreign key
foreign key
A composite key.
foreign key
secondary key
Record