Can you list and explain the types of relationships between tables in a database?

In relational databases, there are three main types of relationships between tables:

1. One-to-One

   • Each record in the first table corresponds to exactly one record in the second table and vice versa.
   • Used when data is logically separated but directly related.

2. One-to-Many

   • One record in the first table can correspond to many records in the second table.
   • For example, one user can have many orders.

3. Many-to-Many

   • Records in the first table can correspond to many records in the second table and vice versa.
   • Implemented through an intermediate (linking) table that contains foreign keys of both tables.

These relationships help structure data and ensure integrity when working with it.