What are different relationships existing in database?

A relationship in database is established when one table has a foreign key that references the primary key of another table. There are three relationships existing between database-

• One-to-one– This simple relationship exists among two tables having same rows or columns.
• One-to-many– Two tables connected by a foreign key and a primary key enjoys one-to-many relationship.
• Many-to-many – It is a complex relationship in which many records in one table is connected to many records in another table.