19 01 18

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – January 19th, 2018 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1. Briefly define pervasive data management and the main problems that must be solved. 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 use 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 (23 points) prof. L. Tanca – January 19th, 2018 Available time: 2h 00m Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ PoliCourses is an online platform that offers courses and related exercises. Exercises are of different types, and each has a maximum score. The score obtained when solving an exercise is computed as the fraction of the maximum score corresponding to the level of completion, plus a possible bonus assigned by the system (e.g., because the student solved the exercise quickly). A student can try each specific exercise only once. The management of PoliCourses has now hired you to design a data warehouse to analyze the results of the exercises performed by the students. The following is the schema of the…