1.

Explain different types of relationships amongst tables in a DBMS.

Answer»

Following are different TYPES of relationship amongst tables in a DBMS system:

  • ONE to One Relationship:  This type of relationship is applied when a particular row in table X is linked to a singular row in table Y.
  • One to MANY Relationship: This type of relationship is applied when a single row in table X is related to many ROWS in table Y.
  • Many to Many Relationship: This type of relationship is applied when multiple rows in table X can be linked to multiple rows in table Y.
  • Self Referencing Relationship: This type of relationship is applied when a particular row in table X is associated with the same table.


Discussion

No Comment Found

Related InterviewSolutions