09 09 15

Pagina 1

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