This is databases. Server: 134.74.126.107 DDatabase: kkdatadb »ETable: kkdata6 S

ID: 3583583 • Letter: T

Question

This is databases.

Server: 134.74.126.107 DDatabase: kkdatadb »ETable: kkdata6 Search Insert Export Import Browse Structure SQL. operations Workno artfirst artlast gertitle engtitle date month dateyear datetext medium dimh dimw credit name Kandinsky Ohne Titel Untitled 912 1912-1913 Watercolor 35.7 39.7 Private Cloppenburg collection on pape StAndtische StAndtische Kandinsky Aquarell No.3 Watercolor 911 911-1912 Watercolor, 40.2 45.2 (Liebesgarten) No.3 (Garden ndia ink Galerie im Galerie of Love and pencil Lenbachhaus Munich on pape 1911-1912 Watercolor, 40.2 45.2 StAudtische StAndtische Kandinsky Aquarell No.3 Watercolo 911 Liebesgarten No.3 (Garden Galerie im Galerie of Love and pencil Lenbachhaus Munich on pape 1911-1912 Watercolor, 28 1911-1912 Watercolor, 28.7 42.8 StAndtische StAndtische Kandinsky Watercolo 911 No.8 Last ndia ink Galerie im Galerie Tag Judgement and pencil Lenbachhaus Munich on pape 1911-1912 Watercolor, 28 1911-1912 watercolor, 28.7 42.8 StAndtische StAndtische Kandinsky Aquarell No.8 Watercolo 911 No.8 "Last Galerie im Galerie Lenbachhaus Tag Judgement and pencil Munich on pape Kandinsky EndgA%ltiger StAndtische StAidtische Final Study for September September Watercolor, 27.7 911 Entwurf fA14 Cover of "The Galerie 911 ndia in den Umschlag Blue Rider blue pencil Lenbachhaus des Almanac Almanach. and pencil Munich on p September watercolor 27.7 21.9 StAndtische StAndtische Kandinsky EndgA%ltiger Final Study for September 911 Entwurf fA4r Cover of "The ndia ink, Galerie im Galerie den Umschlag Blue Rider" blue pencil Lenbachhaus and pencil des Almanac. Almanach Munich on p Kandinsky EndgA%ltiger Final Study for September 911 September Watercolor, 27.7 Entwurf fA14 Cover of "The 911 ndia ink, den Umschlag Blue Rider blue pencil des Almanac. Almanach and pencil on p September watercolor, 27.7 21.9 StAn StAndtische Kandinsky EndgA ltiger Final Study for Septembe 911 Cover of "The Galerie im Galerie Entwurf fAyar 911 ndia ink, den Umschlag Blue Rider" blue pencil Lenbachhaus des Almanac... Almanach... and pencil Munich on p Kandinsky EndgA%ltiger Final Study for September 911 September Watercolor, 27.7 21.9 StAndtische StA dtische Entwurf fA14 Cover of "The 911 ndia ink, Galerie im Galerie den Umschlag Blue Rider blue pencil Lenbachhaus des Almanac. Almanach and pencil Munich ownaddress own city ownzip owncountry Munich 80333 Munich 80333 D Munich 80333 D Munich 80333 Munich 80333 Munich 80333 Munich 80333 Munich 80333

Explanation / Answer

TABLE:ARTIST(BASE TABLE)

WorkNo

ArtFirst

ArtLast

GerTitle

EngTitle

Medium

Dimh

Dimv

OWNNAME

TABLE:EXHIBITION

ExNo

ExNo

DateMonth

DateYear

DateText

Credit

OWN City

WorkNo

TABLE:REFERENCE

RefNo

OWNName

OWNAddress

OWNCity

OWNZip

OWNCountry

WorkNo

4.)ARTIST TABLE CREATION

SQL>CREATE TABLE ARTIST(

WORKNO INT NOT NULL,

ARTFIRST VARCHAR(50) NOT NULL,

ARTLAST VARCHAR(50),

GERTITLE VARCHAR(100) NOT NULL,

ENGTITLE VARCHAR(100) NOT NULL,

MEDIUM VARCHAR(100) NOT NULL,

DIMH DECIMAL(3,2) NOT NULL,

DIMV DECIMAL(3,2) NOT NULL,

PRIMARY KEY(WORNO,GERTITLE,ENGTITLE));

EXHIBITION TABLE CREATION

SQL>CREATE TABLE EXHIBITION

EXNO INT NOT NULL,

DATEMONTH VARCHAR(10) ,

DATEYEAR INT(4) NOT NULL,

DATETEXT VARCHAR(50) NOT NULL,

CREDIT VARCHAR(100) NOT NULL,

OWNCITY VARCHAR(50) REFERENCES REFERENCE(OWNCITY)

WORKNO INT REFERENCES ARTIST(WORKNO)

PRIMARY KEY(EXNO));

REFERENCE TABLE CREATION

SQL>CREATE TABLE REFERENCE

OWNNAME VARCHAR(50) NOT NULL,

OWNADDRESS VARCHAR(200),

OWNCITY VARCHAR(50),

OWNZIP INT,

OWNCOUNTRY VARCHAR(2) NOT NULL,

WORKNONO INT REFERENCES ARTIST(WORKNO)

PRIMARY KEY(WORKNO,OWNNAME));

ARTIST TABLE INSERTION

INSERT INTO ARTIST(WORKNO, ARTFIRST, GERTITLE, ENGTITLE, MEDIUM, DIMH, DIMV,OWNNAME,EXNO) VALUES (1,”KADINSKY”, ”OHENTITLE”,”UNTITLED”,”WATERCOLOR ON PAPER”,35.9,39.7);

INSERT INTO ARTIST(WORKNO, ARTFIRST, GERTITLE, ENGTITLE, MEDIUM, DIMH, DIMV) VALUES (3,”KADINSKY”, ”AQUARELLNO3(LIEBERSGARTEN)”, ”WATERCOLORNO3(GARDENOFlOVE)”,”WATERCOLOR INDIA INKAND PENCIL AND PAPER”,40.2,45.2);

INSERT INTO ARTIST(WORKNO, ARTFIRST, GERTITLE, ENGTITLE, MEDIUM, DIMH, DIMV) VALUES (4,”KADINSKY”,”AQUARELLNO8”JA1/4NGSTERTAG”, ”WATERCOLORNO8LLAST JUDGEMENT”,”WATERCOLOR INDIA INKAND PENCIL AND PAPER”,28.7,42.8);

INSERT INTO ARTIST(WORKNO, ARTFIRST, GERTITLE, ENGTITLE, MEDIUM, DIMH, DIMV) VALUES (6,”KADINSKY”, ”ENDG1/4ITIGERENTUWArfta1/4denumschalgdessALMANC”,”FINAL STUY COVER OF THE BLUDE RIDER ALMANCH”,”WATERCOLOR INDIA INK,BLUE PENCILAND PENCIL AND PAPER”,27.7,29.9);

EXHIBITION TABLE INSERTION

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(1,”1912”,”1912-1913”,”PRIVATE COLLECTION”,”MUNICH”,1);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(2,”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,3);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(3”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,3);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(4,”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,4);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(5,”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,4);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(6,”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,4);

INSERT INTO EXHIBITION(EXNO, DATEYEAR, DATETEXT,CREDIT, OWNCITY, WORKNO) VALUES(7,”1911”,”1911-1912”, ”STAPDISTCHEGALARIE IM LENBBACHHAUS,MUNICH”,”MUNICH”,4);