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.
This was so well done! I'm genuinely impressed. Thank you for putting this together!
You explained this much better than my teacher. Thank you very much for the educational content!
I love the song choices lol
which software do you use to create this er diagram?
Software please
Rammstein spotted 10/10 vid
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"
Amazing video, terrible haircut
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
10/10 as usual