When there is a many-to-many relationship,it is common to have a linking table.A good example is between musicians and record albums,where any musician can record multiple albums,and any record album can be created by multiple musicians.In this case,what would be true of the linking table?
A)It would be composed entirely of the primary keys MusicianID and AlbumID,with no other fields allowed.
B)It would be composed entirely of the foreign keys MusicianID and AlbumID,with no other fields allowed.
C)If the Musicians table has a primary MusicianID value of 21,the linking table would have at least one record with a foreign MusicianID value of 21.
D)It would contain the foreign keys MusicianID and AlbumID and possibly other fields.

Question

Quizplus · Accepted Answer

The linking table would contain the foreign keys MusicianID and AlbumID and could also include additional fields to store more information about the relationship, such as the date of collaboration or role of the musician in the album.

When There Is a Many-To-Many Relationship,it Is Common to Have