What do you mean by a relationship in DBMS? Explain its types.

Question

Accepted Answer

A relationship in DBMS defines how data in one table is connected to data in another table, usually established using primary and foreign keys. Types: (i) One-to-One — each record in one table relates to only one record in another (e.g., a person and their passport). (ii) One-to-Many — one record in a table relates to many records in another (e.g., one teacher teaches many students). (iii) Many-to-Many — records in one table can relate to multiple records in another and vice versa (e.g., students and courses).