The CIA maintains a small database to track its painters, what they are painting and secret galleries that may display these clandestine artwork. Painters are not identified by their individual names, but the abstract motifs they exhibit. For example, SunFire is the name of an artist who is inspired by a haunted visualization of a world scorched by rising temperatures. One example of her (or is it his) work, is depicted in their oil-on-canvas painting titled, Earth: Flame Embroiled. This painting is proudly displayed at the Midnight Moon Gallery in Oxnard. It can be yours for the price of 12 Bitcoin.
Your goal is to construct the design of the CIA database, where a single painting is created by an individual artist and may be exhibited in one and only one gallery at a time. Galleries, of course, may exhibit many different paintings, from many different artists. Similarly, artwork is created by individual artists, but each artist can create numerous artworks. All transactions are performed in the only stable currency, bitcoin (please look up the value of bitcoin for any data needs). Your ERD will include a listing of entities, all primary attributes and datatypes and all appropriate relationships. Be sure to include proper connectivity on both sides of your relationship.