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 6, 2024 Last Name (Surname, Cognome) ______________________ First Name ____________ Codice Persona _________ Consider the ER Diagram representing a data structure for tracking natural disasters. The
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 6, 2024 Last Name (Surname, Cognome) ______________________ First Name ____________ Codice Persona _________ Consider the ER Diagram representing a data structure for tracking natural disasters. The
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 6, 2024 Last Name (Surname, Cognome) ______________________ First Name ____________ Codice Persona _________ Consider the ER Diagram representing a data structure for tracking natural disasters. The following attributes describe the entities. The primary keys are underlined. - Natural Disaster - ID , Start Time, Start Date, End Time, End Date, Disaster Description - Earthquake - Magnitude (1 to 10), Mercalli Scale (1 to 12) - Flooding - Water Height - Landslide - Landslide Class (1 to 5) - Tornado - EF Scale (0 to 5) - Location - Postal Code , City, Country, Description - Person - Personal ID , Name, Surname, Postal Code, - Paramedic - Paramedic ID, Training Level (Novice, Intermediate, or Expert) - Firefighter - Firefighter ID - Policeman - Policeman ID, Rank - Vehicle - Plate , Number of Seats - Ambulance - Stretcher (Yes/No), Defibrillator (Yes/No) - Fire Truck - Water Capacity, Ladder (Yes/No) Note → A paramedic can be a firefighter (the same applies to the other entities involved in that ISA relationship). The following attributes describe the relationships. - Drive (Firefighter – Fire Truck) - Driving License Number - Drive (Paramedic – Ambulance) - Driving License Number - Cause (A Natural Disaster may cause another Natural Disaster) - Causal Description Exercise 1 - Unstructured data models (1 PT) Which DB technology would be the best to store the entities/rel. of the ER diagram? (1 PT) ENTITIES / REL. DB TYPE MOTIVATION Exercise 2 - Neo4j (5 PT) Consider the entities Person, Paramedic, Firefighter, Vehicle, Ambulance, and Fire Truck 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,…
First page of the document.
