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.