DmyBgl> SELECT workno, artlast, gertitle,engtitle, dateyear,datetext FROM kkdata

Question

DmyBgl> SELECT workno, artlast, gertitle,engtitle, dateyear,datetext FROM kkdata6 I vorkno artlaat I gertitle I engtitle Kandi ky l Ohne Titel Untitled Kandi ky 11 No 3 Liebesgarten lor No. Gard f Love 3I Kandinsky l Aquarell No.3 (Liebesgarten) Watercolor No. (Garden of Love) MI Kandinsky l Aquarell No.8 JAkngster Tag" Watercolor No.8 Last Judgement Aquarell No.8 "JAkingster Tag Kandinsky Watercolor No.8 Last Judgement Aquarell No.8 "JAkngster Tag Watercolor No.8 Last Judgement" Kandinsky MI Kandinsky Aquarell No.8 "JAkngster Tag" I Watercolor No.8 "Last Judgement" 6 Kandinsky I EndgAkltiger Entwurf fAhr den Umachlag dea Almanachs Der Blaue Reiter Final Study for cover of The Blue Rider Almanach. 6 Kandinaky I EndgAhltige Entwurf fAhr den Umachlag dea Almanachs Der Blaue Reiter I Final Study for cover of The Blue Rider Almanach r 6 I Kandinsky l EndgAkltiger Entwurf f den Umschlag des Almanachs Der Blaue Reiter I Final Study for cover of The Blue Rider Almanach 6 I Kandinsky I EndgAki tige Entwurf fArr den Umschlag des Almanachs "Der Blaue Reiter" I Final Study for cover of The Blue Ride Almanach 6 I Kandi ky l EndgAMi tiger Entwurf fAAr den Umschlag des Almanachs Der Blaue Reit I Final study for cover of "The Blue Rider" Almanach 6 I Kandinsky l Endgihltiger Entwurf fANr den Umschlag des Almanachs Der Blaue Reiter I Pinal Study for cover of The Blue Rider Almanach Kandinsky Entwurf sition VII Study for "compo sit VII 7 Kandinsky l Entwurf zu Komposition VII Study for Composition VII I Study for Composition VII Kandinsky Entwurf zu Komposition VII 9 Kandinsky Entwurf zu Allerheiligen II I Study for "All Sainte II" 9 I Kandinsky Entwurf zu Allerheiligen II" Study for "All SaintB II" I date year I date text 1912-1913 1912 1911 I 1911-1912 1911 1911-1912 1911 1911-1912 1911 1911-1912 1911 1911-1912 1911 1911-1912 1911 I september 1911 1911 I september 1911 1911 I september 1911 1911 september 1911 september 1911 1911 I 1911 I September 1911. 1913 913 1913 1913 1913 1913 1911 1911 1911 1911

Explanation / Answer

3. The whole table can be divided into four tables:

i) workno(PK), dimh, dimw, gertitle, engtitle, medium, dateyear, datetext. - this table can be named KKArtWork.

ii) workno(FK), credit, ownname, owncity, place - This table can be named Credits

iii) ex_no, ex_date, ex_place, ex_illust, workno(FK) - this table can be named ExDetails

iv) refs_reference, refs_publication, refs_illust, workno(FK) - this table can be named RefsDetails

workno can be used to connect all the tables.

4. CREATE TABLE KKARTWORK(workno int, dimw decimal, dimh decimal, gertitle varchar(255), engtitle varchar(255), medium varchar(255), dateyear int, datetext varchar(255), PRIMARY KEY ( workno ));

CREATE TABLE CREDITS(workno int, credits varchar(255), ownname varchar(255), owncity varchar(255), place varchar(255), FOREIGN KEY(workno));

CREATE TABLE EXDETAILS(workno int, ex_no int, ex_date int, ex_no varchar(10), ex_place varchar(255), ex_illust varchar(255), FOREIGN KEY(workno));

CREATE TABLE REFSDETAILS(workno int, refs_reference varchar(255), refs_publication varchar(255), refs_illust varchar(255), FOREIGN KEY(workno));

Inserting data :

INSERT INTO KKARTWORK(select workno, dimw, dimh, gertitle, engtitle, medium, dateyear, datetext from kkdata6);

INSERT INTO CREDITS(select workno, credits, ownname, owncity, place from kkdata6);

INSERT INTO EXDETAILS(workno, ex_no, ex_date, ex_no, ex_place, ex_illust from kkdata6);

INSERT INTO REFSDETAILS(workno, refs_reference, refs_publication, refs_illust from kkdata6);

The column artlast is completely omitted since it was holding the same value for all the rows and its understandable that the whole table from kkdata6 was describing kandinsky's work.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.