Join the Teckiy Community
Sign up for Free !!
World's first open source developer community with
Ticketing System
Thanks in advance
There are 3 different types of relationships in Structured Query Language (SQL).
1. One-to-one relationships: In a one-to-one (1:1) relationship means one record in a table is related with one and only one record in another table.
For example, in a office database, each employee has only one employee ID, and each employee ID is assigned to only one person.
2. One-to-many relationships: In a one-to-many relationship means one record in a table can be related with one or more records in another table.
For example, each customer can have many sales orders.
3. Many-to-many relationships: A many-to-many relationship means when multiple records in a table are related with multiple records in another table.
For example, customers can purchase many items, and items can be purchased by many customers.