23 02 16

Pagina 1

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,…