24 06 2024 E T

Pagina 1

SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA - Prof. Marco Brambilla - June 24, 2024 Last Name (Surname, Cognome) ______________________ First Name ____________ Codice Persona _________ Consider the ER Diagram representing a data structure for tracking Disney’s digital products. The following attributes describe the entities. The primary keys are underlined. - Company Section - ID , Name, Description, Number of Employees - Digital Content - Title , Release Date, Duration, Production Cost, Minimum Age - Series - Number of Episodes, … - Movie - Sequence Number, Nominated for Award (Yes/No), … - Animated Movie - … - Character - Name , Nickname, Age - Actor - Personal ID, Name, Surname, Age, Birth Date, Career Description - Voice Actor - Voice Tone, Voice Strength (from -5 to 5) - Script - ID , Length, Duration, Title - Location - ID , Name, Description, Furniture (Text), Indoor (Yes/No) - Line - ID , Sequence Number, Text The following attributes describe the relationships. - Perform - Recording Date - Produce - Starting Date, End Date Exercise 1 - Unstructured data models (1 PT) Which DB technology would be the best to store the entities/rel. of the ER diagram? [you may not need all the rows of the table] (1 PT) ENTITIES / REL. DB TYPE MOTIVATION Exercise 2 - Neo4j (5 PT) Consider the entities Character, Actor, Voice Actor, and Line from the ER model. Suppose you want to store the respective data instances in a graph database. Sketch a graph model/example describing the nodes, main attributes, and edges. Either show an example graph or a graph with types. (1 PT) Write a Cypher query to collect the total number of lines that were performed by actors named “Mark” who performed at least 100 lines with at least three characters (2 PT) Write a Cypher query to return the…