01 02 17

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – February 1st, 2017 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1) Describe the dimensional fact model used in the data warehouse context and define its main elements. Provide a small example. 2) Describe the problem of personalization and list the various kinds of personalization with a small explanation of each.  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 – February 1st, 2017 Available Time: 2h 00m Last Name _________________________________________________________________ First Name _______________________________________________________________ Student ID ________________ Signature_______________________________________ PoliRestaurants is a chain of Italian restaurants operating in Lombardy which allows customers to order meals through its website. The customer needs to register, and t hen can navigate to the website, where he/she can choose one of the restaurants of the chain. At this p oint it is possible to order dishes and beverages from the chosen restaurant, specifying for each dish or beverage the required number of items. All the PoliRestaurants restaurants offer take-away service, and in some cities also home delivery is available. UniRestaurants, on the contrary, is a restaurant chain featuring Chinese and…