Author Question: What is an association relationship, and how does it differ from an N:M relationship? What will ... (Read 91 times)

crobinson2013 · **on:** Jul 7, 2018

What is an association relationship, and how does it differ from an N:M relationship?

What will be an ideal response?

Question 2

In the normalization process, if you find a candidate key that is not a primary key, then you have determined that the relation needs to be broken into two or more other relations.

Indicate whether the statement is true or false

stillxalice · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

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, the 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.

Answer to Question 2

FALSE