In a one-to-one relationship, each record in one table is associated with one and only one record in another table.
For example, consider two tables: 'Person' and 'Passport'. Each person can have only one passport and each passport can be issued to only one
Show more…