Converting Relationship of Cardinality(M:N)

A new table is created in this type of cordinality to represent the relationship.

M-N

It has to contain two Foreign Keys to one from each of the particiipants in the relationship.

The Primary Key of the new table is the combination of the two Foreign Keys.

Entity Relationship In this table of course we have two foreign keys that is (studentcode, course id) Table representation

Course table attribute CourseID (pk) is a foreign key for Enroll table of attribute CourseID.

StudentID of table student is a "Foreign Key" for table enroll for attribute "Student_Code".




Facebook Likes

Youtube