Could somebody check my ER Diagram and how I transformed them into relations?

[sim18]

I have attached my ER-Diagram, and from that I have transformed them into relations.

Can somebody check them before I move on to normalize the relations?

Entity-Sets.

Medium(mediaType_id, description)
Paintings(paintings_id, title, height, width)
Artist(artist_id, artistName, birth, death, nationality)
Style(styles_id, description)
Gallery(gallery_id, name, locations, city, postcode)
Exhibition(exhibition_id, exhibitionTheme)

Relationships.

Applied-on (mediaType_id, painting_id)
Paints (artist_id, paintings_id)
Paint-In (artist_id, styles_id)
Held-In (paintings_id, exhibition_id)
Holds (gallery_id, exhibition_id)

Constraints.

No two galleries can be the same.
Paintings cannot be on display in more than one gallery.
Paintings cannot feature in more than one exhibition.
A painting is painted by only one artist.
Artists must have a name.
Every style has one artist.


Thanks for your time.

 

[Simon_MT]

Paintings > Artist
Paintings > Medium
Paintings > Style

Exhibition > Gallery

Rational Artists are not restricted to a particular style - they evolve their style although an Artist can be a member of a particular movement.

An Exhibition is held at a Gallery

Simon