Question
Objective The aim of this project is to design a database for a simple blogging platform using MySQL, Neo4j and MongoDB databases. Students are expected
Objective The aim of this project is to design a database for a simple blogging platform using MySQL, Neo4j and MongoDB databases. Students are expected to gain an understanding of all the steps involved in using/designing relational, graph and document-based databases. Due Date Final report is due on April 19th, 2018 through elearn (11:59 p.m). Description Each user can sign up with their name, lastname, and email. A user may choose to follow'' other users. A user may post a blog which consists of a title and a feed. Each post (blog) might have zero or more comments. A blog may be liked by a user. A blog may have multiple tags (zero or more). A tag may be attached to multiple blogs (zero or more). A comment or a blog 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 blogs list according to the network of a user (his/her blogs and people he/she follows). Profile page list users profile information, the people he/she follows and feeds of that user. How to proceed? 1. [5 pts] Draw the ER diagram for RDBMS. Include this diagram in your report. 2. [5 pts] Draw the graph diagram (direct graph) for Neo4j. Include this diagram in your report. 3. [5 pts] Draw the UML class diagram for MongoDB. Include this diagram in your report. 4. [5 pts] Write SQL queries to implement your blogging database in MySQL. Include these queries in your report. 5. [5 pts] Write Cypher queries to implement your blogging database in Neo4j. Include these queries in your report. 6. [5 pts] Write queries to implement your blogging database in MongoDB. Include these queries in your report. 7. [5 pts] Implement (generate) your blogging database in MySQL. Include the screenshot of your database generated. 8. [5 pts] Implement (generate) your blogging database in Neo4j. Include the screenshot of your database generated. 9. [5 pts] Implement (generate) your blogging database in MongoDB. Include the screenshot of your database generated. 10. [5 pts] Using MySQL queries (SQL) o add at least 50 blog records with five different users to the MySQL database. o add at least five different users to the MySQL database. o include these queries in your report. 11. [5 pts] Using Neo4j queries (Cypher) o add at least 50 blog records to the Neo4j database. o add at least five different users to the Neo4j database. o these records should be same with the ones in 10. o include these queries in your report. 12. [5 pts] Using MongoDB queries o add at least 50 blogs records to the MongoDB database. o add at least five different users to the MongoDB database. o these records should be same with the
i just the need the SQL part
SEA CommENT text tng firshae at strig Objeetn Bla.blog a:created.on TAG tas CLoC stig. title Strina: Pec Date : created enStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started