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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started