TYPES  OF  RELATIONSHIPS  IN  DBMS

RELATIONSHIP :

                                      A Relationship is describes the relation between amonngg the entities . The relationship are denoted by diamond symbol (<>) . There are  four types of relationships are there :

(i) one-one relationship

(ii) one-many relationshiip

(iii) many-one relationship

(iv) many-maany relationship

(i) one-one relationship : 

                                     In this table each record of one table is related to only one record of  another table .

(ii) one-many relationship :

                                    In this relationship eacch record of one table is related to one (or) more than one record of another table .

(iii) many-one relationship :

                                  In this relationship morethan one record of one table can be related to only one record of another table .

 

 (iv) many-many relationship :

                                 In tthis relationship morethan one record of one table can be related to morrethan one record of another table .