Full exam for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: Technologies for Information Systems Part I (10 points) prof. L. Tanca – September 21st, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________
Full exam for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: Technologies for Information Systems Part I (10 points) prof. L. Tanca – September 21st, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________
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.
Technologies for Information Systems Part I (10 points) prof. L. Tanca – September 21st, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1) Define Wrappers and Mediators, explain in which circumstances their use is advised in Data Integration and the way they work. Discuss the various types of Wrappers and Mediators that have been introduced during the course. 2) Describe the Box -Plot method for displaying the distribution of data, using an example to illustrate it clearly. Technologies for Information Systems Part II (22 points) prof. L. Tanca – September 21st, 2016 Available time: 2h 00m Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ PoliRestaurants is a restaurant chain selling home -delivery meals in Italy through its website. Each order is associated with just one dish, and the customers may choose the restaurant to which the delivery is requested. Each dish has a full price, but a discount may be applied when the customer completes the order; the restaurant chain proposes promotions varying continuously, therefore each order is associated with its own discount. The management of PoliRestaurants has now hired you to design a data warehouse to analyze the orders. The following is the schema of the PoliRestaurants operational database: RESTAURANT (RestaurantName, Address, CityName, SupervisorSSN, NumberOfEmployees) SUPERVISOR (SupervisorSSN, Surname, GivenName) CITY (CityName,…
First page of the document.
