Mapping Binary M:N Relationships,”A binary M:N cannot be mapped directly into relations without creating an intersection relation (aka association table, junction table, etc.)Ex. STUDENT(StudentID, Name, Major, Year)COURSE(CourseID, Title, Topic)ENROLLS(StudentID, CourseID

Average Rating
0 out of 5 stars. 0 votes.

Mapping Binary M:N Relationships,”A binary M:N cannot be mapped directly into relations without creating an intersection relation (aka association table, junction table, etc.)Ex. STUDENT(StudentID, Name, Major, Year)COURSE(CourseID, Title, Topic)ENROLLS(StudentID, CourseID

Date)What is the primary key in enrolls? The comboCould add date to part of the composite key to fix redundancy issue”