Thread: Types of relationship in SQL

Hi. I am new in database world. I want detailed information on types of relationship in SQL. If you have any in solution please let me know that .it is very helpful for me. Thank you.

The entities have a set of properties linked with them. E.g. each employee has a set of properties such as emp no, Name, Father’s name etc. When we create tables linked with entities, the properties become fields of these tables. In an employee table, each employee has more than one phone numbers linked with him. Such association is also referred to as relationship.

There are 3 types of relationships.

1. One-to-one relationship

2. One-to-many relationship

3. Many-to-many relationship