Question: write java program to do the following (interacting with database version): Add records to LIKE_GROUP table. o It queries the classify table for the records
write java program to do the following (interacting with database version):
Add records to LIKE_GROUP table. o It queries the classify table for the records with the same group name and extracts out the artworks for those records.
o Then it queries for the artist names of these artworks.
o Finally it should add records to the LIKE_ARTIST table combining the artists name and customer id if that combination is not already recorded.
Implementing update functionality for the style field of artist o It should update the style field of the artist record identified by the given artists name to the new style value.
Reading from the database. There is a set of read operations that should be implemented for certain tables to create a report.
o Get the list of artists. o Get the list of artworks.
o Get the list of groups.
o Get the list of classify entries.
o Get the list of like group entries.
o Get the list of like artist entries.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
