Database Reference
In-Depth Information
Both CourseID and RegNo together are the primary key of the relation, admission.
3.8.2
Rule: Mapping 1:M relationships
For binary 1:M relationships, we have to find what kind of participation constraints the M
side of the relationship has. For binary 1:M relationships, if the M-side has full participa-
tion, include the key of the entity from the 1 side, in the relation on the M side as a foreign
key.
Example 7:
For example, in following ERD, we assume full participation on the student side,
we will have:
