Technology: HTML, Java, MySQL, Neo4j Graph Database, Eclipse, Apache Server

This project involved designing entity-relation diagrams (ER diagram), implementing the diagram
in SQL DDL statements, entering over 250,000 rows of real Twitter data into the database, performing
complicated SQL queries on the data, optimizing these queries, and creating the same queries for a
corresponding Neo4j graph database.

For the final part of the project, my team (two others) and I used a local Apache server to make a
web application in Eclipse using JSP files (Java server page) that connected to the database. The
app allowed the user to perform the same queries as mentioned earlier on the Twitter database.

The entity-relation diagram:

projectDDL.sql (click on image to download file): This is the SQL file that implements the above design

projectInsert.sql (click on image to download file): This is the SQL file that inserts the data into the database from the specified csv files

These are the descriptions for the SQL queries that we made on the Tweet database

querySolutions.sql (click on image to download file): This file contains the queries that yield the outputs of the descriptions above

Queries.cipher (click on image to download file): These are the corresponding Neo4j (graph database) cipher queries. They give the same results as the SQL queries but are
written for a graph database

The login page for the web app:

After the user logs in, they will be able to run any of the queries on the database:

Q1.jsp (click on image to download file): HTML description for the
user input of the first query on the web application

ResultQ1.jsp (click on image to download file): The page that shows the results
of the query after the user enters the information

Results of Q1:

Results of Q3:

Results of Q6:

Results of Q9:

Results of Q10:

Results of Q11:

Results of Q15:

Results of Q18:

Results of Q23: