HERE IS WHERE YOU CAN WORK ON PLEASE CHECK THIS AND WORK ON THIS PLATFORM BOOKCLUB Database

data mining

Description

Directions: For each question, answer the question in a document to upload to Canvas and include screenshots of the queries and results. If possible, include in your screenshot unique identifying information, such as a tab open in your browser, your name on the computer, or unique wallpaper (This is not necessary for the social network you create as that should be unique). 

HERE IS WHERE YOU CAN WORK ON PLEASE CHECK THIS AND WORK ON THIS PLATFORM BOOKCLUB Database

https://ds220su19.ist.psu.edu/playground/cypher/bookclub/view/pgdb____1573746337_5dcd76a13f319 

 

Have a look at the nodes of the graph, using the default command:

MATCH (n)
RETURN n;

NOTE: neo4J is case-sensitive for the entities in the database (e.g., Book, Genre). It is not case-sensitive for the neo4j commands (i.e., MATCH is the same as Match)

 

Try this query:

MATCH (r: Reader) -- (book:Book) -- (genre:Genre)
WHERE genre.name = 'humor'
RETURN r.name

 

Question 1: How many records does it return? Describe what this query does. Show a screenshot  (5).

 

Question 2: Write a Cypher query to find all the people in the database who like detective books (There is a genre called 'detective'). Show a screenshot. Describe, in words, how your query works. (10)

 

Question 3: Create a query that will return "Jenny Jennifers'" friends who like 'humor' books.
Show a screenshot of your query and what is returned . (10)

 

Question 4: Create a query to find a list of books that no one likes (HINT: in addition to WHERE, Cypher also can handle WHERE NOT; the results may look unusual. Describe what this means).  (15)

Make sure your screenshot shows the query and what is returned. 

 

 

Question 5: 

Using the book club database, write a cypher query that finds the genre with the most liked books by ordering books in the genre from MOST liked to LEAST liked. (Hint: Like SQL, in cypher you can count things(vertices or edges). You can then also ORDER BY ). Describe how your query works.(15)

 

Question 6: Clear the database by running the following command:

Instruction Files

Related Questions in data mining category