Types of relationships in Database

Question

Can someone enlist the various types of relationships in database?

Answer 1

There are 3 types of relationships in Database:

• One-to-one: One table has the relationship with another table having the similar kind of column. Each primary key relates to only one or no record in the related table.
• One-to-many: One table has a relationship with another table that has primary and foreign key relation. The primary key table contains only one record that relates to none, one or many records in the related table.
• Many-to-many: Each record in both the tables can relate to many numbers of record in another table.

Answer 2

There are 3 types of relationships in relational database design. They are:

• One-to-One
• One-to-Many (or Many-to-One)
• Many-to-Many