Database Management System20785 marksMapping one-to-many relationships
During ER-to-Relational Mapping, explain with example to map 1: N and N:M relationship into a relation?
During ER-to-Relational Mapping, explain with example to map 1: N and N:M relationship into a relation? [5]
In a 1:N relationship, the entity on the N-side (many-side) gets the primary key of the 1-side entity added as a foreign key in its relation. No new relation is created. 1. Create relations for both participating entity types. 2. Identify the entity on the many side. 3. Add the primary key of the...