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 II prof. L. Tanca – September 9, 2015 Available Time 1h 50m Last Name _______________________________________________________________________ First Name _______________________________________________________________________ Student ID
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 II prof. L. Tanca – September 9, 2015 Available Time 1h 50m Last Name _______________________________________________________________________ First Name _______________________________________________________________________ Student ID
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 II prof. L. Tanca – September 9, 2015 Available Time 1h 50m Last Name _______________________________________________________________________ First Name _______________________________________________________________________ Student ID __________________ Signature __________________________________________ PoliCars and UniCars are two car dealers. PoliCars sells cars manufactured by several manufacturers, but not Fiat; on the contrary, UniCars sells cars coming only from the Italian manufacturer Fiat. The two dealers have recently merged into a unique company named UniPoliCars. Each company relied on its own relational database describing the features of the cars on sale, and t he UniPoliCars ownership now asks you to integrate them into a unique one. You must perform the integration assuring to lose the least possible amount of information. The original relational schemas of the two sources are reported in the following. PoliCars MANUFACTURER (ManufacturerName, Country) MODEL (ManufacturerName, ModelName, LaunchYear) VERSION (ManufacturerName, ModelName, VersionName, Price, CarDoorNumber, MaxSpeed, Consumption_L_Km, ABS, EngineCode) // Consumption_L_Km indicates the quantity of fuel consumed per kilometer, e.g., 0.005 L/Km); ABS is a boolean value that is true if this version has the ABS. ENGINE (EngineCode, Displacement, NumberOfCylinders, Power) AIRBAGTYPE (AirbagTypeName, Description) // Airbag type examples: front, side, rear, … VERSIONAIRBAGTYPE (AirbagTypeName, ManufacturerName, ModelName, VersionName) CAR (CarId, ManufacturerName, ModelName, VersionName, BuyingDate, Color) UniCars MODEL (ModelName, LaunchYear, SegmentId) SEGMENT (SegmentId, Description) VERSION (VersionId, VersionName, ModelName, Cost, CarDoorNumber,…
First page of the document.
