My table have many duplicated entries, is it dangerous if I don't fix this? My table is structured like this:
Music_id | Music_title | Music_author | Music_link 1 Look at me now Chris Brown 2 Look at me now Jay-z
This is just an example, but that is the table I have. Look at the Music title. There's duplicate entries already. Sometimes the music_title will reach 10 duplicates
So I plan to make a look up Music table
Music id | music_title 1 Look at me now My table id | music | music_author | Music_link 1 1 chris brown 2 1 jay-z
But my concern is, the 1 in the music field is also duplicated. Which is better anyway? I'm confused.