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)
Relationship between base data(workno, gertile,medium,artlast..) and reference fields are fully functional
dependent. Based on two or more attributes we can fetch other fields.
Now this table in 1st normal form. We need to conform to BCNF or 4th normal form.

---------------------------------------------------------------------------------------------------------------------------------------
2) Work no cannot use as primar key since it is unique oer record.
We need to add new column id which should be unique and it serves as primary key.

--------------------------------------------------------------------------------------------------------------------------------------
3)
Here is new tables which will be in BCNF.

Workers(ID (PK), workno,ex_date,ex_no)
kkdata6(ID (PK & FK), ex_place,ex_iilust,refs_publication .. so on)

Here id as separate attribute which will serve as primary key. Sp, two tables are connected with each
other will our unique key ID and it will be shared by both tables.

----------------------------------------------------------------------------------------------------------------------------------------
4)
Here is new tables which will be in BCNF.

Workers(ID (PK), workno,ex_date,ex_no)
kkdata6(ID (PK & FK), ex_place,ex_iilust,refs_publication .. so on)

Here id as separate attribute which will serve as primary key. Sp, two tables are connected with each
other will our unique key ID and it will be shared by both tables.

-----------------------------------------------------------------------------------------------------------------------------------------
5) Yes
Work, exhibition place,exhibition data -> exhibition number
exhibition_date, place, number -> workno

These all fields are fully functional dependency.
But now with our new tables there will not be any functional dependencies.

----------------------------------------------------------------------------------------------------------------------------------------------------
6)
In both tables, ID attribute will play role as primary key, in kkdata6 table ID will play role as foreign key too..

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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