Full exam for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: Technologies for Information Systems Part I (10 points) prof. L. Tanca – February 10th, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student
Full exam for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: Technologies for Information Systems Part I (10 points) prof. L. Tanca – February 10th, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student
Import quality: text was extracted directly from the original document.
Representative passages recognised in different parts of the material. The full extracted text remains available to search, while this compact preview makes the page easier to read.
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…
First page of the document.
