Create a database to track artists and their paintings.For each artist we want to record – their first and last name, their country of birth, their date of birth, current city, street name, and street number address, their telephone number, and some general comments. You may want to assign a unique artist ID to each artist.For each painting we want to record, the name of the painting, the style, the date painted, the type of canvas used, and other fields you feel appropriate. I suggest assigning a unique painting ID to each painting – or stating that each painting name must be unique.
Assume: each artist may paint many paintings; each painting is painted by a single artist.
“Real” data is not required; for the extra credit Access DB – you can make up names for painting, artists, etc.
Sample Solution
