I am practising some E-R model questions and came across this.
Construct an E-R model for an art gallery. A number of artists may exhibit their paintings at the gallery. Each artist has a unique id, name (first name and last name) and an address (street, town and postcode). Each painting has a unique id, a title, date completed and price associated with it. The gallery also has a number of customers who have purchased paintings from the gallery. Each customer has a name, address and phone number(s).
I have so far constructed an artist entity with its attributes (ID as primary, composite name, composite address) and painting(ID as primary, date of completion as dervied, and rest as it is). But I need some help with the relationship advisor between the two and the gallery parts. Just a textual decsription will suffice. Thanks!
