Sobes.tech
Middle

What types of relationships between tables can be called?

sobes.tech AI

Answer from AI

In relational databases, the following main types of relationships between tables exist:

  • One to one (1:1) — each record in the first table corresponds to exactly one record in the second table and vice versa.
  • One to many (1:N) — one record in the first table corresponds to many records in the second table.
  • Many to many (M:N) — records in the first table can correspond to many records in the second table and vice versa; implemented through an intermediate linking table.

For example, a "one to many" relationship — one author can have many books, and each book belongs to one author.