database

Question 36 20 pts For the following table and associated functional dependencies, 1. State the highest normal form the table can be in (e.g. if it violates 3NF but does not violate 2NF, the highest normal form it can be in is 2NF) 2. Normalize the table through 3NF and write normalized tables in shorthand notation 3. Identify all candidate keys PAINTING Artist Name Painting_Year Artist_Nationality Painting Size Martini Hey Painting_Title Madonna and Child Margaret of Austria The Annunciation Landscape at Zaandam Two Young Girls at the Piano A Bear Walking Warwick Castle: the East FrontCanaletto The Elephant Clock Bridge over a Pool of Water Lillies Monet 1326 1490 Botticell 1485 1871 1892 Da Vinci 1490 1752 Al-Jazari 1315 1899 Italian Dutch Italian French French Italian Italian Syrian French 57.2 x 38.4 32.7 x 23 19.1 x 31.4 45.7 x 67 111.8 x 86.4 10.3 x 13.3 31.6 x 56.2 30 x 19.7 92.7 x 73.7 Monet Renoir Painting Title -> Artist Name, Painting_Year, Artist_Nationality, Painting Size Artist_Name - -> Artist_Nationality HTML Editor