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 23rd, 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 23rd, 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 23rd, 2016 Available time: 25 minutes Last Name _________________________________________________________________ First Name ________________________________________________________________ Student ID ________________ Signature_______________________________________ 1) Define what is a Data Mart in a Data Warehouse and clearly summarize the methodological steps that lead from a collection of datasets to the specification of the logical schemas of one or more Data Marts. (7 points) 2) Define the concept of association rule in the data mining context, and give a small example. (3 points) Technologies for Information Systems Part II (22 points) prof. L. Tanca – February 23rd, 2016 Available Time: 2h 00m Last Name _________________________________________________________________ First Name _______________________________________________________________ Student ID ________________ Signature_______________________________________ PoliHighways and UniRoads are two companies managing roads. PoliHighways deals only with highways, i.e. roads with a toll to be paid by the drivers. UniRoads, on the contrary, manages a wider variety of roads, including both highways a nd free-of-charge roads; to manage the latter UniRoads receives a contribution by a funding body, typ ically a public administration. Each company relies on its own relational database describing the managed roads, the toll payments and the maintenance works. The two companies adopt different systems for the toll payments . More in detail, PoliHighways adopt s a closed system: vehicles have to cross an entrance tollbooth and an exit tollbooth, and the price to be paid is determined on the basis of the covered distance. On the contrary,…
First page of the document.
