You finally got yourself a fancy new gig and you've been put in charge of making a program to keep track of paintings, and the galleries that contain them.
Each painting has a style (eg. "impressionist", "abstract", "finger painting"), and a title. Each artist has a name and an amount of years active, and each gallery has a name and a city.
The bare bones have been created for you already, but you'll have to build out the rest. Get to it! Ignore the people who say "Don't, champ!". Do Champ! (get it? Like, DuChamp? Cuz he made art. Look, it's all I got.)
Here's what we need to be able to do.
ARTIST
-
Get a list of all artists
-
Get a list of all the paintings by a specific artists
-
Get a list of all the galleries that a specific artist has paintings in
-
Get a list of all cities that contain galleries that a specific artist has paintings in
-
Find the average years of experience of all artists
PAINTING
-
Get a list of all paintings
-
Get a list of all painting styles (a style should not appear more than once in the list)
GALLERY
-
Get a list of all galleries
-
Get a list of all cities that have a gallery. A city should not appear more than once in the list.
-
Get a list of artists that have paintings at a specific gallery
-
Get a list of the names of artists that have paintings at a specific gallery
-
Get the combined years of experience of all artists at a specific gallery