JAVA

Suppose you have been given the following ER diagram for critics review of music songs. 1- Implement the upsert operation for critiques table for both cases: a) JDBC and b)JPA (by upsert, we mean, if the data exists update it with input data and if not then insert it. You also need to implement a SongsDAO class that offers ICRUD functionality. 2- The songs review website exposes an API to external clients. The API takes as input the genre code and returns a list of songs belonging to that genre. If the genre code is not provided(or is null/empty) then all the songs will be returned. For each song, id, title, number of critiques and average score will be returned. Provide the implementation of this API either as SOAP or REST. Use JPA entities in question 1.

genres code varchar(7) name varchar(70) songs id int (7) title varchar(70) genres_code varchar(7) date_of_release DATE critics id int (7) name varchar(66) surname varchar(66) email varchar (66) critiques critic_id int (7) song_id int (7) rating int (10) comments varchar (66) genres code varchar(7) name varchar(70) songs id int (7) title varchar(70) genres_code varchar(7) date_of_release DATE critics id int (7) name varchar(66) surname varchar(66) email varchar (66) critiques critic_id int (7) song_id int (7) rating int (10) comments varchar (66)