Need help creating an associative entity for a Many-to-Many relationship. I know that in a M:M relationship, a junction table (associative entity) is created between the two entities. Product and Song are in a M:M relationship. Song and Singer are in a M:M relationship as well. But I'm not sure what attributes goes into the new tables. The associative entity for Product and Song would have both Primary Keys (ProductID and SongID). Also, same goes for the other associative entity for Song and Singer (SongID and SingerID).

Attributes for Product entity are ProductID (PK), Product_title, Type, Unit Price, Quantity_on_hand, and SupplierID (FK).

Attributes for Song entity are SongID (PK), Category, Date_released, Song_title, and Length.

Attributes for Singer entity are SingerID (PK), Artist_Name, Record_Label, DOB, Gender, Manager_Contact, and Email.

Attributes for Product-Song (associative entity#1) entity are ProductID (PK1,FK1), SongID(PK2,FK2), .......other attributes???

Attributes for Singer-Song (associative entity#2) entity are SingerID (PK1,FK1), SongID(PK2,FK2), .......other attributes???

Business Rules:

1. A product can be included in one or more songs.

A song can be remixed into a one or more products.

2. A song can be sung by one or more singers.

A singer can sing one or more songs.