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

What will be an ideal response?

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.

Business

You might also like to view...

During logical database design, the work of all systems development team members is coordinated and shared through:

A) the project dictionary. B) scheduled weekly meetings. C) the project leader. D) JAD sessions. E) walkthroughs.

Business

A minority of HR managers check applicants' backgrounds

Indicate whether this statement is true or false.

Business