one-to-one relationship

An association between two tables in which:

•e primary key value of each record in the primary table corresponds to the value in the matching field or fields of one and only one record in the related table.

•e primary key value of each record in the related table corresponds to the value in the matching field or fields of one and only one record in the primary table.