SQL HELP!!!!!!!!!

Part 1

Design the database using the ER approach and then create the tables accordingly. Populate the tables so that each table contains at least 10 tuples. Then using Java and SQL, implement the following functionality:

Implement a button called Initialize DB. When a user clicks it, your database will be initialized with all tables and tuples; all students should use database name sampledb with password pass1234.

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.

Part 2

Based on part 1, 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.Insert/delete/update a paper (all attributes except the paper id).The paper id should be generated by the system automatically using MySQL autoincrement.

2.Insert/delete/update a PC member (all attributes except the member id).The member id should be generated by the system automatically using MySQL autoincrement.

3.Insert/delete/update a review report (all attributes except the report id). The report id should be generated by the system automatically using MySQL autoincrement.

4.List all the papers by Lu (last name) as the single author.

5.List all the papers in which Lu is the first author.

6.Find all the papers coauthored by Zhang and Lu.

7.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.

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

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

10.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.

Important: Your system must be web-based. All functionality must be performed via the interface of your system, direct SQL statement execution via any tools (MySQL workbench) is not allowed except during debugging.