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

1. The base data refers to a work having a work number whihc gets exhibited using some reference. Exhibition and refreence have their own details whch can be mapped to the base data. one work number can be exhibited in multiple places and hence might bear multiple references. So the reklation between base to exhibition ONE : MANY:& base to reference is also ONE : MANY

hence the relation between base : exhibition : reference is ONE: MANY: MANY

This is forieign key dependency.

2. workno can be used as a Foreign key.

Yes

3. yes it can be decomposed to BCNF

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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