I hv 3 table artists, songs and albums.i have doubt

Question

I hv 3 table artists, songs and albums.i have doubt

in creating the relationships between them.
1.Artists can song many songs
and Song can also be sing by more than one artist.

so that relationship be many-many on both ways right?

0

13.07.2022

8 ответов

14 просмотров

Thomas

You could make a new table something like "artist_songs" or "performances"

0

13.07.2022

i aspirant Автор вопроса

Thomas
You could make a new table something like "artist_...

song can be sing by one or more artist.For example consider 2 artist sing a song.likewise a artist can also sing many songs

0

13.07.2022

Thomas

i aspirant
song can be sing by one or more artist.For example...

Then my solution with a new table works

0

13.07.2022

Thomas

i aspirant
song can be sing by one or more artist.For example...

New table contains: artist_id | song_id

0

13.07.2022

i aspirant Автор вопроса

Thomas
New table contains: artist_id | song_id

but the new table automatically created like correct since we are utilizing many-many mappings

0

13.07.2022

Thomas

i aspirant
but the new table automatically created like corre...

Well that depends on what you're using

0

13.07.2022

i aspirant Автор вопроса

Thomas
Well that depends on what you're using

i was told to use ef code first approach!

0

13.07.2022

Thomas · Accepted Answer

Thomas

I don't think it's the same song if it is sung by a different artist eh?

0

13.07.2022

Похожие чаты

I hv 3 table artists, songs and albums.i have doubt

8 ответов

Похожие вопросы