Top Posters
Since Sunday
36
35
33
31
30
30
30
30
28
28
28
27
New Topic  
wrote...
Posts: 91
2 months ago
What is an association relationship and how does it differ from a many-to-many (N:M) relationship?
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 16 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 127
2 months ago
Sign in or Sign up in seconds to unlock everything.
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
  332 People Browsing
Related Images
 427
 90
 15