Homework 5

.docx

School

Northeastern University *

*We aren’t endorsed by this school

Course

7275

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by BailiffRoseWaterBuffalo94

Homework 5 IE 6700 Data Management for Analytics Group – 13 Student 1: Samiksha Baraskar baraskar.s@northeastern.edu Student 2: Dinesh Chalicheemala chalicheemala.d@northeastern.edu Problem 1 : Chapter 11 (11.3E) Using the Neo4j book club database in this chapter, can you do the following using Cypher queries? a. Find a list of books no-one likes. ANS: MATCH (b:Books) WHERE NOT (b)-[:LIKES]-() RETURN b; b. Find all pairs of people that have no liked books in common. ANS:

MATCH (r1:Reader), (r2:Reader) WHERE NOT (r1)--(:Book)--(r2) AND NOT r1.name = r2.name RETURN r1.name, r2.name

c. Find the genre with the most liked books. ANS: MATCH (g:Genre)--(b:Book)-[z:LIKES]-(r:Reader) RETURN g.name, COUNT(z) ORDER BY COUNT(z) DESC

d. Find the person who has the most likes in common with a given, another person. ANS: MATCH (r1:Reader)--(b:Book)--(r2:Reader) RETURN r1.name, r2.name, COUNT(b) ORDER BY COUNT(b) DESC

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help