Hi @yavisht,
Thanks for the post.
The simplest implementation of the Relationship field would be to create a relationship field for each of your pages and filter the post according to to the post type ie either Exhibition, Collection or artist.
I hope this helps.