Datebase 2 - Master of Computer Science

***TASK1 (a,b,c,d)***

Datenbanken II Advanced Database Concepts TU Clausthal, Institut fr Informatik Due date: 7 February 2023, 13:00 Please read carefully In this assignment we will use Neo4j again and practise role management and database security. For the exercises, we will use the "Movie Database", which was already used in the first assignments and can be found on Moodle. Hint: You can find an overview of all Cypher commands under this url: com/docs/cypher-ref card/current/ Include all essential ideas and steps that are necessary to derive a solution in addition to an answer of a question. Write your solution in an understanding form or draw the respectively structure with some tool you might find fitting. You may need to format your files into .pdf! If there is missing information make an assumption and add it as a statement in your solution. Your assumption will hold for the entire assignment, if not declared otherwise. Task 1 3 Marks In this task, we will practice the user-defined procedures and functions in NEO4J. You can read more about extending NEO4J under this 2 URLs: https:/eo4j.com/ docs/java-reference/current/server-extending/ and https:/eo4j.com/blog/ intro-user-defined-procedures-apoc/. (a) Explain in your own words the advantages of using user-defined procedures in NEO4J. (b) Write a cypher query to retrieve all procedures (c) Write a function that returns the movie name by passing a parameter (movie id), deploy it to NEO4J and run it as a cypher statement in NEO4J. (d) Write a function that returns the names of all actors that acted in a specific movie (actor id is a parameter), deploy it to NEO4J and run it as a cypher statement