Top Posters
Since Sunday
27
26
25
22
21
21
21
20
20
20
19
19
New Topic  
wrote...
Posts: 95
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 17 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 130
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
  371 People Browsing
 139 Signed Up Today
Your Opinion
Where do you get your textbooks?
Votes: 94

Related Images
 1067
 708
 427