What are the types of relationships in a database?

• One-to-One (1:1): Each row in one table is linked to one row in another table.
• One-to-Many (1:M): A row in one table can be linked to many rows in another table.
• Many-to-Many (M:N): Rows in one table can be linked to many rows in another table

and vice versa. This often requires a junction table.