Question
JAVA AND SQL HELP!!!!! Description Consider the design of the following database system for managing a particular conference: a collection of papers are submitted to
JAVA AND SQL HELP!!!!! 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.
Part 1
Design the database using the ER approach. Then using Java and SQL, implement the following functionality:
1. Implement a button called Initialize Database. When a user clicks it, all necessary tables will be created (or recreated) automatically, with each table be populated with at least 10 tuples so that each query below will return some results. All students should use the database name sampledb, username john, and password pass1234.
2. Create the functionality to assign three reviewers to a paper.
Your system must be web-based. Some simple GUI interfaces are required for each functionality. All functionality must be performed via the interface of your system, direct SQL statement execution via any tools (MySQL workbench) is not allowed.
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