Ask a Question
  
  
  
Top Posters
Since Sunday
8
7
7
6
6
6
6
5
5
5
5
5
New Topic  
wrote...
Posts: 24
6 days ago
What is an association relationship and how does it differ from a many-to-many (N:M) relationship?
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 10 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 22
Rep: 4 0
6 days ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
An association relationship is very similar to an N:M relationship except that the intersection table has attributes of its own. This means that in addition to the foreign key fields linking to the two strong entities, there is at least one additional field in what would otherwise be called the intersection table but is now an association table. For example, intersection table ENROLLMENT for STUDENT and CLASS showing student enrollment in each class would normally have two columns: StudentID and ClassID. However, we can turn this intersection table into an association table by adding the column Grade, which records each student's grade in each class.
This verified answer contains over 100 words.
Related Topics
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  233 People Browsing
 170 Signed Up Today
Related Images
 991
 79
 61