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.
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…
First page of the document.
