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
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#)
Converting relationship of cardinality 1:N (one to many)
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)
