Esame completo di SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA per il corso di Computer Engineering presso Politecnico di Milano. Materiale proveniente dall’archivio storico Studwiz e classificato per la consultazione online.
Esame completo di SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA per il corso di Computer Engineering presso Politecnico di Milano. Materiale proveniente dall’archivio storico Studwiz e classificato per la consultazione online.
Qualità dell’importazione: il testo è stato estratto direttamente dal documento originale.
Passaggi rappresentativi riconosciuti nelle diverse parti del materiale. Il testo completo resta presente nella pagina per la ricerca, mentre l’anteprima compatta rende più semplice la lettura.
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,…
Prima pagina del documento.
