In a one-to-one relationship between
records in two linked tables, for every record in the primary table there is
only one matching record in the lookup table (based on the linked fields). For
example, in the Xtreme database, the Employee table can be linked to the
Employee Addresses table based on the Employee ID field in each table. The
Employee table contains information about employees at the company, the
positions they hold, their salaries, hiring information, and so on. The
Employee Addresses table contains each employee's home address. There is only
one record for each employee in each of these tables. Therefore, if the
Employee table is linked to the Employee Addresses table, only one record will
be found in the Employee Addresses table for each record in the Employee table.
This is a one-to-one relationship.