What are the types of relationships used in Database modeling?

In database modeling, the primary types of relationships are one-to-one, one-to-many, and many-to-many. A one-to-one relationship means a single record in one table is linked to a single record in another table. A one-to-many relationship allows a single record in one table to be associated with multiple records in another table. Lastly, a many-to-many relationship occurs when multiple records in one table relate to multiple records in another, often necessitating a junction table to manage the associations.