Relationship

Hi Andrew, Thank you for the post, in answer to your question;
A one-to-one relationship exists where for every one record in the primary table there is one and only one matching record in another table i.e. a table comprising employee information and a table comprising salary information may be created because each employee has only one entry in the salaries table.

This form of relationship is used in the following scenarios:
1. Security