10 02 16

Pagina 1

Technologies for Information Systems Part I (10 points) prof. L. Tanca – February 10th, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1) Describe concisely the concept of mashup and its utility in data integration, highlighting its distinctive features w.r.t. using other integration techniques. 2) Briefly define pervasive data management and the main problems that must be solved. Technologies for Information Systems Part II (22 points) prof. L. Tanca – February 10th, 2016 Available time: 1h 50m Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ PoliCo is a big company composed of many branches in various countries , and whose employees are often on travel for business reasons. Each business trip is performed by an employee and is associated with a certain expenditure item. The trip must be authorized by the employee who is responsible for that expenditure item. Since business trips represent a very relevant expense for PoliCo, the management of the company asked you to design a data warehouse to analyze them. The following is the schema of the PoliCo operational database: BUSINESSTRIP (SSNEmployee, StartingDate, DurationInDays, FoodCost, LodgingCost, TransportationCost, DestinationCity, ExpenditureItemCode) EMPLOYEE (SSN, Surname, GivenName, HomeCity, Role, BranchName) // Role may assume the values “Clerk”, “Manager” or “Technician”. CITY (CityName, Country) EXPENDITUREITEM…