Long description

Back

The image contains 2 tables. Table 1 labeled “ArtWork table” consists of 4 columns and 5 rows. The column headings, center aligned, are as follows: ArtWork I D, Title, Artist I D, and YearOfWork. The row entries, left-aligned are as follows. First row: ArtWorkID column, 345. Title column, The Death of Marat. ArtistID column, 15. YearOfWork column, 1793. Next row: ArtWorkID column, 400. Title column, The School of Athens. ArtistID column, 37. YearOfWork column, 1510. Next row: ArtWorkID column, 408. Title column, Bacchus and Ariadne. ArtistID column, 25. YearOfWork column, 1520. Next row: ArtWorkID column, 425. Title column, Girl with a Pearl Earring. ArtistID column, 22. YearOfWork column, 1665. Last row: ArtWorkID column, 438. Title column, Starry Night. ArtistID column, 43. YearOfWork column, 1889.

Table 2 labeled “Artist table” consists of 2 columns and 5 rows. The column headings, center aligned, are as follows: ArtistID and Artist. The row entries, left-aligned, are as follows. First row: ArtistID column, 15. Artist column, David. Next row: ArtistID column, 22. Artist column, Vermeer. Next row: ArtistID column, 25. Artist column, Titian. Next row: ArtistID column, 37. Artist column, Raphael. Last row: ArtistID column, 43. Artist column, Van Gogh.

Column “ArtistID” of Table 1 is the Foreign Key. Column “ArtistID” of Table 2 is the Primary Key. An arrow from 22, under column Artist I D, Row 4 in ArtWork table points to 22, under column Artist I D, Row 2 under Artist table.

Another arrow from 43, under column Artist I D, Row 4 in ArtWork table points to 43, under column Artist I D, Row 2 under Artist table.

Back