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.
SYSTEMSANDMETHODSFORBIGANDUNSTRUCTUREDDATA- Prof.MarcoBrambilla- Sept6,2024 LastName(Surname,Cognome)______________________FirstName____________CodicePersona_________ Consider thefollowingERDiagram Thefollowingattributesdescribetheentities. Theprimarykeysareunderlined.- Person- Personal_ID, Name, Surname, BirthDate, PhoneNumber- Owner - (...), Owner Since, E-mail- Customer - (...), E-mail- Waiter - (...), HiringDate- Chef - (...), HiringDate- HeadChef - (...), HeadChef Since- Restaurant - Restaurant_ID, Name, MaximumNumber of Guests, Address, PhoneNumber- Table- Table_ID, TableNumber, MaxSeats- Dish- Dish_ID, Name, Price, Recipe, Description- Ingredient - Ingredient_ID, Name, Allergies(Yes/No) Thefollowingattributesdescribetherelationships.- Book- Number of People, BookingDate N.B. ThereisonlyoneHeadChef per Restaurant. TablesareservedbymoreWaitersoverall, but onlyoneat atime. DishesarecookedbymoreChefsoverall, but onlyoneat atime. Exercise1- Unstructureddatamodels(1PT) WhichDBtechnologywouldbethebest tostoretheentities/rel. of theERdiagram?[youmaynot needall therowsof thetable] (1PT) ENTITIES/ REL. DBTYPE MOTIVATION Exercise2- Neo4j (4.5PT) Consider theentitiesCustomer, Table, Waiter, andDishfromtheERmodel andsupposeyouwant tostoretherespectivedatainstancesinagraphdatabase.Sketchagraphmodel/exampledescribingthenodes, mainattributes, andedges.Either showanexamplegraphor agraphwithtypes. (1PT) WriteaCypher querytocollect thetotal number of different dishesthat wereservedat eachtable, consideringonlytableswhosemaxseatsisgreater than10andservedbyat least onewaiter whosenameis“Federico” (1.5PT) WriteaCypher querytocollect thetotal number of customersservedbyeachwaiter,consideringonlycustomerswhobookedatablebefore18/08/2024andwhoorderedat least5dishesduringoneof their…
Prima pagina del documento.
