Can we say that the Entity Album is weak and is dependent on the entity Song? As an album can only exist if it has songs in it, but a song can exist without it being in an album no?
Weak entity instances need to be associated with exactly one instance of the strong entity that owns them, so they cannot be in a many-to-many relationship. Therefore, the Album must be a strong entity.
There are several assumptions in the model that make this not possible. Every song is sung by exactly one artist. There can be one artist and multiple featured artists, but with only one artist associated with each song, it would not be possible for multiple artists to have the same first song. In this model, a song corresponds to a specific recording of the song, so multiple people may have their own version of the same lyrics, but ultimately a specific recording of a song belongs to only one artist.
You explained this much better than my teacher. Thank you very much for the educational content!
This was so well done! I'm genuinely impressed. Thank you for putting this together!
I love the song choices lol
Can we say that the Entity Album is weak and is dependent on the entity Song? As an album can only exist if it has songs in it, but a song can exist without it being in an album no?
Weak entity instances need to be associated with exactly one instance of the strong entity that owns them, so they cannot be in a many-to-many relationship. Therefore, the Album must be a strong entity.
I think Artist could be a composite attribute composed of something like "primary artist" and "featured"
which software do you use to create this er diagram?
What about when one song is the first song of multiple artists? Will the relation still remain 1-to-1 or m-to-1
There are several assumptions in the model that make this not possible. Every song is sung by exactly one artist. There can be one artist and multiple featured artists, but with only one artist associated with each song, it would not be possible for multiple artists to have the same first song. In this model, a song corresponds to a specific recording of the song, so multiple people may have their own version of the same lyrics, but ultimately a specific recording of a song belongs to only one artist.
wonderful
Rammstein spotted 10/10 vid
Software please
Amazing video, terrible haircut
10/10 as usual