What are the three types of relationships between datasets in a database?

Question

Accepted Answer

There are three types of relationships between datasets in a database: one-to-one, one-to-many, and many-to-many.

One-to-one: each record in one dataset is related to only one record in another dataset.
One-to-many: each record in one dataset is related to one or more records in another dataset.
Many-to-many: multiple records in one dataset are related to multiple records in another dataset.
Examples: one-to-one - employee and social security number; one-to-many - customer and orders; many-to-many - students and classes.

Accepted Answer

1.Many to one relationship