consider the five relation schemas with the primary key underlined:

artist $($id$,$ name, status$)$

work $($id$,$ name, work$\_$type, price$).$

gallery $($id$,$ name, location$)$

exhibition $($id$,$ gallery$\_$id$,$ start$\_$date, end$\_$date$)$

transaction $($id$,$ buyer, work$\_$id$,$ date, price, status$)$

The attributes in artist mean the following: id is a unique identifier for an artist; name is the name of the artist, and status takes two values, $$active$$ or $$inactive$.$