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

mikaylakyoung · **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

The MySQL IF statement is used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test.

Indicate whether the statement is true or false

johnpizzaz · **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, 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

TRUE