Long description

Three tables labeled Artists are shown in the left, and three tables labeled paintings are shown on the right. Table 1: Paintings has 4 fields: PaintingsID, Title, ArtistID and YearOfWork. Table 2: Artists has 2 field: ArtistID and Name. Table 1 has many to 1 relationship to Table 2. Table 3: Paintings has 4 fields: PaintingsID, Title, ArtistID and YearOfWork. Table 4: Artists has 2 field: ArtistID and Name. Table 3 has N to 1 relationship to Table 4. Table 5: Paintings has 4 fields: PaintingsID, Title, ArtistID and YearOfWork. Table 6: Artists has 2 field: ArtistID and Name. Table 5 has 1 to 1 relationship to Table 6.