Converting Relationship in Schema In DBMS:

The way relationships are represented depends on the cardinality and degree of relationship. Possible cardinalities are 1:1, 1:M, N:M

Partial total

case 1: Combination of participation Type
The primary key of the partial participant will become the foreign key of the total participants.

Relationship Schema is

Employee(E#, Name,......)
Department (Dept#, Name,...... Mgr#)

partial participant

Converting relationship of cardinality 1:N (one to many)

one to many relationhip

In this primary key of the relation on '1' side of the Relationship becomes a foreign key in the relation on the 'N' side.

Teacher( ID, Name, teacher,....) Subjects(Code, Name,...... teachers)

converting one to many

Facebook Likes