03 07 17

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – July 3rd, 2017 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1. Describe the Box -Plot method for representing statistical data , using an example to illustrate it clearly. 2. Describe the main differences between materialized and virtual data integration, explaining which of these two approaches is used in the case of Data Warehousing and why.  During this part of the exam, students are not allowed to consult books or notes.  Students should answer the theoretical questions using their own words, in order for the teachers to be able to assess their real level of understanding. Technologies for Information Systems Part II (22 points) prof. L. Tanca – July 3rd, 2017 Available time: 2h 00m Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ PoliMultiplex is a chain of multiplex movie theaters operating in Italy. In order to watch movies the customers must necessarily obtain a fid elity card, and each ticket issued by PoliMultiplex is associated with the customer that has purchased it and stored in the operational database of the company. The operational database contains also information about the theaters of the chain, the showings, and the programmed movies; each movie is also associated with the main actors that it features. The management of PoliMultiplex has now hired you to design a data warehouse to analyze the…