Full exam for SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA in the Computer Engineering degree programme at Politecnico di Milano. The document covers: 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
Full exam for SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA in the Computer Engineering degree programme at Politecnico di Milano. The document covers: 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
Import quality: text was extracted directly from the original document.
Representative passages recognised in different parts of the material. The full extracted text remains available to search, while this compact preview makes the page easier to read.
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…
First page of the document.
