I would suggest 3 tables, Artist, Aliases, and Albums.
Artist table will have real names, and a linked record field where you can add the aliases.
Alias table will be just that, a list of aliases, but once the aliases are linked in the Artist table, they will also automatically show up in the Alias table.
Album table will have a linked record for the Alias. That way when you click on the Alias record, you can see the Artist real name, and could use a rollup to get the real name in the Album table if you like.
Additionally, you should be able to use a rollup field in the Artist table to get the list of albums.
I didn’t test this, but I think the logic will work.