Database modeling – Relationships

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships are:

one to one one to many many to many

Let’s discuss each of these in detail to understand these relationships with an example.

One to One

A relationship is called a one-to-one relationship if a row of one table has exactly one related row