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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!