30 08 2022 E T

Pagina 1

SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA Prof. Marco Brambilla August 30, 2022 Last Name _________________ First Name ____________ Codice Persona _________ A travelling agency stores data about its customers. Each customer is defined by name, surname, birthdate, address, personal id number, email, and mobile phone number. Customers pay the agency to organise their travels. Each travel request is described by a unique identifier, maximum budget of the customer (the fee own to the agency is not considered here), starting date, end date, number of people, and general description provided by the customer about the trip they would like to do (e.g., “I would like to visit maritime cities in south Italy”). Each travel is assigned to one of the workers of the agency. Each worker is described by name, surname, birthdate, address, personal id number, email, mobile phone number, and an IBAN. The worker then arranges all the things needed for the travel proposal, namely they take care of: - Transportation – described by departure place, departure date, departure time, arrival place, arrival date, arrival time, price, means of transportation - Stay – described by name of the structure, address, arrival date, departure date, check-in time, check-out time, price, list of services provided by the structure (e.g., wifi, air conditioning, etc.), rating out of 5 stars (only if the structure is a hotel), customers rating, description. - Events – described by start date, start time, end date, end time, description, price, address When the travel proposal is complete, the agency contacts the customer and sends them the preview. Each proposal has a status attribute (with default value “WIP”) and a unique identifier. If the customer accepts the proposal, its status is updated to…