Please write the query in Java - creating the SQL statements question 1-6. Thank you.

For questions 1-6, WRITE SOMETHING SIMILAR TO THIS :

Description

Consider the design of the following database system for managing a particular conference: a collection of papers are submitted to the conference, each of which has a unique paper ID, a list of authors (names, affiliations, emails) in the order of contribution significance, title, abstract, and a PDF file for its content. The conference has a list of program committee (PC) members to review the papers. To ensure review quality, each paper is assigned to 3 PC members for review. To avoid overloading, each PC member is assigned with at most 5 papers, assuming that there are enough PC members. Each review report consists of a report ID, a description of review comment, a final recommendation (accept, reject), and the date the review report is submitted. A PC member can submit at most one review report for the paper that is assigned to him/her.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Implement the following functionality using Java and SQL with simple GUI interface. Populate each table with sufficient tuples so that each query below will return some results.

1.) List all the papers in which Lu is the first author.

2.) Find all the papers coauthored by Zhang and Lu.

3.) List the PC member who reviews the most number of papers; if there is a tie, list all PC members that are part of the tie.

4.) List the PC members who have no papers assigned to them for review.

5.) List all papers rejected by both PC members Matt and John.

6.) A paper is considered to be accepted when it gets at least 2 accept recommendations, and rejected otherwise. Define a VIEW called AcceptedPaper and then display all the accepted papers in the system.

Reviewers (String paper id, string r id1, stringr id2, string r id3 ( //add your code to update paper with given id //to add reviewers //similar to insert Data PreparedStatement pstmt; try t pstmt conn-preparestatement("update reviewers set paper id-? where reviewer id pstmt.setstring(1, paper id) pstmt.setString(2, r id1)5 int count pstmt. executeUpdate() catch (SQLException e) f /I TODO Auto-generated catch block e-printstackTrace() try f pstmt-conn-preparestatement ("update reviewers set paper id pstmt.setstring(1, paper id) pstmt.setstring (2, r id2): int count -pstmt.executeUpdate ? where reviewer id ?"); catch (SQLException e) TODO Auto-generated catch block e-printStackTace) Reviewers (String paper id, string r id1, stringr id2, string r id3 ( //add your code to update paper with given id //to add reviewers //similar to insert Data PreparedStatement pstmt; try t pstmt conn-preparestatement("update reviewers set paper id-? where reviewer id pstmt.setstring(1, paper id) pstmt.setString(2, r id1)5 int count pstmt. executeUpdate() catch (SQLException e) f /I TODO Auto-generated catch block e-printstackTrace() try f pstmt-conn-preparestatement ("update reviewers set paper id pstmt.setstring(1, paper id) pstmt.setstring (2, r id2): int count -pstmt.executeUpdate ? where reviewer id ?"); catch (SQLException e) TODO Auto-generated catch block e-printStackTace)