How would I set up the tables in Mysql as I don't I understand what the necessary tables are? like what would be the 10 tuples?

Consider the design of the following database system for managing a social network

website: each user is registered with the website with a username, password, first name,

last name and an email. Username and email are unique. Each user is associated with a

list of hobbies, selected from the following list: hiking, swimming, calligraphy, bowling,

movie, cooking, and dancing. A user can follow a list of other users and can also be

followed by another list of users. See

https://steemit.com/ for an example. Moreover, a

user can post a blog, modify the blog and delete it afterwards. Given a blog, another user,

and only another user can give a comment to the blog, modify the comment or delete the

comment afterwards. To ensure the quality of the website, each user can post at most 5

blogs a day and each user can give at most 7 comments in one day. For each blog, the

user who posted the blog cannot give any comment (no self-comment) and another user

can give at most one comment. Each blog is identified by a blogid, subject, description,

and a list of tags for search purposes. Each comment is identified by a commentid, a

sentiment (positive or negative), and a description.

For all parts of this project, your system must be application or 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 1 Deadline: 2 Weeks 11/05/2018

Use 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. Implement a user registration and login interface so that only a registered user can

login into the system.