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

Multiple Choice

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.