Thanks for the suggestion, I'll experiment with the 3rd table to see how it works out.

I still have one concern: there is nothing to prevent the SelectedItem from pointing to...

Sure, I think it should be possible to have a Person without a selected Mugshot. Or, more generally, a list does not necessarily have to have a selected item.

A...