Database Management for Smart Teacher1 ONLY

profilejohndoe74
artmuseumweek4.accdb
Home>Information Systems homework help>Database Management for Smart Teacher1 ONLY
ArtistID Name Age BirthPlace Style Died UserID
1 Jackson Pollock 60 US Abstract 5/8/12 1
2 Pablo Picasso 45 Germany Cubism 1/19/50 2
3 Marc Chagall 25 Spain Cubism 10/8/81 3
4 Sonia Delaunay 80 UK Abstract 8/10/01 16
5 Hokusai 65 Japan Impressionism 1/21/61 17
6 Camille Pissaro 39 US Impressionism 2/1/01 18
7 Paul Seurat 90 Italy Pointillism 3/15/71 19
8 Leonardo Da Vinci 55 US Realism 6/10/85 20
9 Thomas Eakins 41 US Realism 7/12/87 10
10 Salvador Dali 90 Italy Surrealism 1/22/51 4
ArtworkID Title Year Price ArtistID LocationID
1 Mona Lisa 1/10/56 1000000 8 1
2 The Great Wave off Kanagawa 10/4/11 200000 5 2
3 Raft of the Medusa 5/5/61 1000000 7 2
4 Mozarabic Beatus 7/8/76 2000000 3 4
5 Navajo rug 2/7/80 1500000 4 3
6 Dynasty 12/15/80 100000 5 1
7 Cave 10/20/03 100000 9 5
8 Venus of Willendorf 6/25/00 1000000 1 3
9 Daniel-Henry Kahnweiler 11/10/50 2000000 2 1
10 Dora Maar au Chat 7/10/41 1000000 2 1
EventID ArtistID
1 1
2 1
3 2
4 2
5 3
6 2
7 4
8 4
9 1
10 1
EventID EventName EventDesc
1 Christmas crafting Christmas crafting
2 Art Speak Art Speak
3 Healthy, humours and paintings Healthy, humours and paintings
4 Looking at Japanese erotica Looking at Japanese erotica
5 Redisplaying the Armoury Redisplaying the Armoury
6 University Challenge University Challenge
7 Work Experience Taster Day Work Experience Taster Day
8 An evening with Edmund de Waal An evening with Edmund de Waal
9 Porcelain stories from the Fitzwilliam Porcelain stories from the Fitzwilliam
10 Being Modern in Britain: Ben Nicholson and Barbara Hepworth Being Modern in Britain: Ben Nicholson and Barbara Hepworth
FacultyID FacultyName Gender DOB Type UserID
1 Peter Male Admin 5
2 Steve Male Staff 6
3 Afridi Male Staff 7
4 Ross Male Staff 8
5 Taylor Female Admin 9
6 Maxwell Male Staff 11
7 Firdose Female Staff 12
8 Sunil Male Staff 13
9 Irfan Male Staff 14
10 Broad Male Staff 15
FeedbackID VisitorName Comments ArtworkID
1 JB Very Good 1
2 Mike Excellent 1
3 John Average 2
4 Ten Poor 2
5 Darren Average 2
6 Hick Good 3
7 Yong Excellent 3
8 Muhammad Good 1
9 Umar Excellent 4
10 Hasan Very Good 5
LocationID LocationName
1 Abstract Location
2 Cubism Hall
3 Impressionism Hall
4 Pointillism Hall
5 Realism Hall
6 Surrealism Hall
7 Cubism Hall
8 Cubism Hall 2
9 Surrealism Hall 2
10 Pointillism Hall 2
RegisterID ArtistID ArtworkID RegisteredDate WorklistID
1 1 2 9/9/12 1
2 1 1 9/1/12 2
3 1 3 9/11/12 3
4 2 4 9/11/12 4
5 3 5 9/11/12 5
6 4 6 9/11/12 6
7 2 7 9/11/12 7
8 3 8 9/11/12 8
9 5 9 9/11/12 10
10 6 10 9/11/12 9
RoleID RoleType RoleDesc
1 Artist Artist Roles
2 Staff Staff Roles
3 Admin Admin Roles
UserID UserName Password RoleID
1 OmerPA 123456 1
2 WatsonUS java1232 1
3 HusseyAU 654321 1
4 McKayAU 987654 1
5 PeterAD java123 3
6 SteveST java123 2
7 AfridiST java123 2
8 RossST java123 2
9 TaylorAD java123 3
10 Hogg java123 1
WorklistID WorkDesc DateCompleted FacultyID
1 Work 1 1
2 Work 2 1
3 Work 3 2
4 Work 4 2
5 Work 5 3
6 Work 6 4
7 Work 7 5
8 Work 8 4
9 Work 9 2
10 Work 10 4
SELECT artist.Name FROM Locations INNER JOIN (Artist INNER JOIN Artwork ON Artist.ArtistID = Artwork.ArtistID) ON Locations.LocationID = Artwork.LocationID WHERE LocationName = 'Abstract Location';