The aim of this project is to design and implement a simple Twitter-like social networking platform using

both MySQL and Neo4j graph databases. Students are expected to gain an understanding of all the steps involved in using both relational and graph databases for a practical application.

Each user can sign up with their name, lastname, and email.

A user may choose to follow'' other users.

A user may post a feed.

Each feed might have zero or more comments.

A feed may be liked by a user.

A feed may be re-tweeted.

A comment or a feed should be able to deleted by the owner when needed.

There is no restriction of the number of characters for a feed or comment.

Login page a person should be able to sign up.

Main page displays news feeds according to the network of a user (his/her feeds and people he/she follows).

Profile page list users profile information, the people he/she follows and feeds of that user.

How to proceed?

Draw the ER diagram for RDBMS and the graph diagram (direct graph) for NoSQL (Neo4J).

Implement your database andSQLqueries using MySQL.

Add at least50-100 records to each table.

Implement your database and Cypher queries using Neo4j.

Add at least 50-100 records for each data label.

Design and implement your web application. You should only have one application which should beable to work either with MySQL Neo4j.

Final submission

a)A pdf of the report (named lastname-firstname.pdf) that contains the following items.

Brief introduction: Explain your project briefly.

Database design: An ER and graph diagrams either hand-drawn or drawn using Vision/PowerPoint/ERWin/MySQLWorkbench

Physical database: Screenshots of your tables and their listed data.

Queries: Write the SQL and Cypherqueries you designed accompanied by a brief explanation ofthe purpose of each query.

GraphicalUI: A brief outline of the type of architecture or technology used in theimplementation (What needs to be installed to run your software? What technologies did you

use?, etc.). Add screenshots for the UI screens you implemented