java only. please upload the java file.

1. Consider the design of a database for a web site of youtube videos for comedy standup shows, in which each youtube is exactly for one comedian. Each youtube video is identified by a unique URL (such as https://youtu.be/buSv1jjAels), a title and a description of the youtube, the date on which the youtube is posted, and a list of tags (each tag is a single word in lower cases). A registered user can search for youtube videos by the name of a comedian or by the tags of videos, using a text field like the one used by google.com, and then click any youtube link in the result list to play that youtube video. Each comedian has a first name, a last name, a birthday, and a birthplace. Moreover, registered users can post and comment on these youtubes. Each registered user is identified by a unique username, which must be an email, a password, a first name, a last name, the gender, and his/her age. A registered user can give at most one review for each youtube video, but on a particular day, the user can post at most five youtube videos. The review given by a user has a score of {Poor, Fair, Good, Excellent} and then a short remark. A user can also modify an existing review as well as deleting an existing review. Each user has a favorite list of comedians. Each user can insert and delete a comedian from that favorite list. A new comedian can be added to a list when the user is watching a comedians video that interests him/her by clicking the Add to favorite comedians button. The system has a distinguished user called root whose username is root (this is the only username that is not an email).

For all parts of this project, 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) can only be used for debugging purposes.

Part 1

Use Java and SQL, implement the following functionality:

1. Implement a user registration and login interface so that only a registered user can login into the system. The root user has a username root and password pass1234 (Note this is a different root it is for the website, not a user for the MySQL database system). Sign up for a new user with information such as: username (which is an email), password, password confirmed, first name, last name, age. Duplicate username should be detected and fail the signup. Unmatching passwords should be detected as well.
2. For the root user, implement a button called Initialize Database. This button will only be displayed after the root user signed in successfully. For the Initialize Database button, when a user clicks it, all necessary tables will be created (or recreated if they pre-exist) automatically, with each table be populated with at least 10 tuples so that each query below will return some results.