Study material for SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA, shared by the Studwiz community and reviewed by moderators.
Study material for SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA, shared by the Studwiz community and reviewed by moderators.
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.
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.…
First page of the document.
