← Indietro
EsameEsame completoTesto d’esame

16 02 2024 E T

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.

SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATAEsame completo

Informazioni sul documento

Cosa trovi in questo materiale

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.

Contenuti estratti dal documento

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.

Pagina 1

Consider thefollowingERDiagram Thefollowingattributesdescribetheentities. Theprimarykeysareunderlined.- Company- Code, Name, FoundingDate- Game- Number of Players, MinimumAge, PublicationDate- CardGame- Name, Set Number, (...)- BoardGame- Name, Duration(inMinutes), Description, (...)- Expansion- Name, ExpansionNumber, Description, (...)- Card- CardNumber, Name, Type, Description- GamePiece- PieceNumber, Color, Description- RuleBook- RulebookCode, Title, Introduction- Rule- ID, RuleNumber, Description Databases(1PT) (Usual Exercise) - (1PT) Neo4j (4.5PT)Consider theBoardGame, Expansion, GamePiece, RuleBook, andRuleentities. (Usual Exercise) - (1PT) Q1- WriteaCypher querytocollect thenumber of boardgameswithadurationgreater than10minutesfor whichat least threeexpansionswerereleased(1.5PT) Q2- WriteaCypher querytocollect therulebooksassignedtoboardgameswithat least 10gamepieces, includingat least twowhosedescriptionis“Player Marker”. Amongthose,consider onlyboardgamesfor whichat least oneandat most threeexpansionswerecreated. (2PT) MongoDB(5.5PT)Consider theCardGame, Card, Expansion, andRuleentities. (Usual Exercise) - (1PT) Q1- Writeaquerytocollect all thecardgameswhoseset number isgreater than10andforwhichat least onecardhasitstypeequal to“sorcery”. PerformthequerystartingfromtheCard_Game_Collection. (1PT) Q2- Writeaquerytocount thenumber of cardsfor eachcardtype, finallyreturningonlythetypeswhosecount isgreater than100or lessthan10. PerformthequerystartingfromtheCard_Game_Collection. (1.5PT) Q3- Writeaquerytocount thenumber of cardgameswithat least threeexpansions, oneofwhichshouldbenamed“IceAge”, andat least onecardnamed“MysticRemora”, whosetypeis“Enchantment”. PerformthequerystartingfromtheCard_Game_Collection. (2PT) Elasticsearch(4PT)Consider theBoardGameentity.…

Anteprima

Prima pagina del documento.

Prima pagina: 16 02 2024 E T