Relationships are created by linking the column in one table with the column in another table. There are four different types of relationship that can be created.
The relationships are listed below:
One to One Relationship
Many to One relationship
Many to Many relationship
One to One relationship
One to Many & Many to One Relationship:
For a One to many relationships, a single column value in one table has one or more dependent column values in another table. Look at the following diagram:
Many to Many Relationship:
The third table acts as a bridge between the tables that want to establish a Many to Many relationship. The bridge table stores the common information between Many to Many relationship tables. Have a look at the following diagram:
