07 07 15

Pagina 1

Technologies for Information Systems Part II prof. L. Tanca – July 7, 2015 Available Time 1h 50m Last Name: ____________________________________________________________ First Name: ____________________________________________________________ Student ID: ______________ Signature: _________________________________ PoliAir and UniAir are two Italian airflight companies. Currently they have two distinct databases (i.e., one data source for each company ) and two distinct web sites. The two companies want to create one single website, called UniPoliWebSite. The new web site allows passengers to buy tickets of both companies. The owners of PoliAir and UniAir are sure that the new integrated web site will increase customer satisfaction and hence also the income of both companies. The owners of PoliAir and UniAir asked you to create the integrated database used by the UniPoliWebSite web site. You nee d to integrate the databases (sources) of the former companies in order to be able to query all the available data. The original relational schemas of the two sources are reported in the following. PoliAir FLIGHT (FID, DepartureAirportID, ArrivalAirportID, DepartureTime, ArrivalTime, StandardPrice) // StandardPrice is the price for the journey without discounts. Examples of airport ids are MXP, LIN, FCO, LCY, JFK. FLIGHT-WEEKDAYS(FID,WeekDay) // Indicates for which days of the week each flight is planned SERVICETYPE (IDST, Description) // Examples of valid values of Description are DutyFreeShopping and Restaurant service. SERVICETYPE-FLIGHT (FID, IDST) // Used to store the set of available services for each flight. PASSENGER (PassengerID, Password, SSN, Name, Surname, Address, City, ClientCategory) // ClientCategory can assume the values Gold or Silver. SSN = social security…