Build a graph database that shows relationships between characters in Shakespeare's Romeo and Juliet.

Task 1:  We first need to build a Neo4J database called play

 

Task 2: 

1. Then we need to identify a list of characters that appear in the play.
2. For each character, create a corresponding "Character" node in Neo4J.
3. Make sure to identify appropriate attributes that describe each character (e.g., name, age, gender, family).
4. Make sure to save your queries in a separate text file

Task 3: 

1. Identify a list of scenes that take place in the play
2. For each scene, create a corresponding "Scene" node in Neo4J
3. Make sure to identify appropriate attributes that describe each scene (e.g., scene number, title, duration)
4. Make sure to save your queries.

Task 4:

1. Create relationships between characters and scenes.  Label the relationships between characters and scenes as "APPEARS_IN".
2. Create relationships between character nodes.  Make sure to build the following types of relationships:
   1. FAMILY
   2. FRIEND
   3. ROMANTICALLY_INVOLVED
   4. RIVAL
       

Task 5: Writing a CYPHER query to show the entire graph

 

Task 6: Writing a CYPHER query to show all characters that appear in any scene with ROMEO
 

Task 7: Writing a CYPHER query to show all characters that are rivals

 

Task 8: Writing a CYPHER query to show all characters that appear in the same scene and are related to each other (FAMILY).