How best to represent "aliases"/nicknames?

[F_K]

hi, i have a table with a list of musicians’ real names.
now, many of them use multiple aliases / nicknames / pseudonyms

now i have another table listing albums
sometimes, i need to credit the same artist twice, with different aliases

and later i need to be able to retrieve all related data

how best to model this?

[Elias_Gomez_Sai]

No because the Alias that aren’t Artists are not in the Artists table.

An Artist represent the person, who has date of birth, family, start of career, and so on. The Aliases are the ‘alter-egos’ of that persons, than can have style of music, photo (different for each alias), and so on.

If an Artist just have one Alias, it seems silly to have the Artist record, but that structure allows you to have several Alias, let’s say in the same song, even for the same Artist.

[F_K]

so, in the albums list, i need to list all personnel

how do i do this?

i make a linked record to the artists table, and now i need to pick from the alias column

but sometimes i need the artist name as well!

[Elias_Gomez_Sai]

I think you need to read the thread again

Elias_Gomez_Sainz:

The idea is to have the “original name” also as an Alias:

• Artist: Tim Bergling
• Aliases: Tim Bergling, Avicii