Question - What are the different type of relationships in the DBMS?
Answer -
Relationships in DBMS depicts an association between the tables.
Different types of relationships are:
- One-to-One: This basically states that there should be a one-to-one relationship between the tables i.e. there should be one record in both the tables. Example: Among a married couple, both wife and husband can have only one spouse.
- One-to-Many: This states that there can be many relationships for one i.e. a primary key table hold only one record which can have many, one or none records in the related table. Example: A Mother can have many children.
- Many-to-Many: This states that both the tables can be related to many other tables. Example: One can have many siblings and so do they have.