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

question 17

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.

---

Definitions:

Cost of Merchandise Sold

The total expense incurred by a company to buy or manufacture the goods sold during a period.

Gross Profit

The difference between revenue from sales and the cost of goods sold, before deducting overhead, payroll, taxation, and interest payments.

Sales

The transactions involving the exchange of goods or services for money, reflecting the primary revenue source for most businesses.

Operating Income

Earnings from a company's main business activities, excluding expenses like interest and taxes.