I have an entity that cannot exist without being defined by another, and I want this entity to participate in a many to many relationship.
Example: An artist has an album (the album cannot exist without an artist), the album also has many tracks, but the same track can exist in many albums.
So we have a many to many relationship between the album and the tracks.
If the album is also a weak entity, then its primary key, is a foreign key referencing the artist, thus it cannot be a foreign key to another table representing an m to m relationship.
The question is: is it possible to have this kind of relationship in SQL, and if so, how do I express it?