In Access there are three types of relationships.

A one-to-one relationship, one row of data in Table A may be associated with only one row of data in Table B. For example, a business may have a table containing information about employees. Since the employees frequently travel internationally, they also have another table to store information about employee passports. Each employee has only one passport and a passport belongs to only one employee.

In a one-to-many relationship, one row of data in Table A may be associated with many rows of data in Table B. In a database named Mary's Rentals, for example, there is a one-to-many relationship between the Customer and Order tables. A customer can have many orders, but a particular order is associated with only one customer.

In a many-to-many relationship, many rows of data in Table A may be associated with many rows of data in Table B. In Mary's Rentals there is a many-to-many relationship between the Order and Equipmenttables. An order can be for many different pieces of equipment, and a particular piece of equipment can be on many different orders.

I just described the following relationships: a one-to-one relationship, a one-to-many relationship, and a many-to-many relationship.

For this discussion, provide an example of when each type is useful. Incorporate examples that relates to your day-to-day life in every aspect you can think of, work, study, household, family, friends, fantasy football, etc.