07 09 18

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – September 7th, 2018 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1. Briefly define data management in pervasive systems and the main problems that must be solved. 2. Describe the two techniques GAV and LAV for data integration in the case of the existence of a Global Schema, and underline the main pros and cons of the two approaches. • 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 – September 7th, 2018 Available time: 2h 00m Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ PoliBeach is a company owning a chain of beach resorts. All the beach resorts owned by PoliBeach offer their customers the same set of packages, each associated with the rental of various objects like beach chairs and beach umbrellas. Each package has a daily rental cost, and the customer purchases the package for a certain number of days. The director of a beach resort may negotiate the sale price with the customers, deciding to apply a discount percentage that may be different for each sale. The management of PoliBeach has now hired you to design a data warehouse to analyze the sales of…