11 09 14

Pagina 1

Technologies for Information Systems Part II prof. L. Tanca – Sept 11, 2014 Available Time 1h 50m Last Name ______________________________________________________________ First Name ______________________________________________________________ Student ID _______________ Signature ____________________________________ PoliBet and SoccerBet are two Italian bookmaking companies. PoliBet is a general- purpose bookmaker for sport events, while SoccerBet is specialized in soccer bets. 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 PoliWebBet. The new web site allows gamblers to bet using both companies. The owners of PoliBet and SoccerBet are sure that the new integrated web site will increase customer satisfaction and hence also the income of both companies. The owners of PoliBet and SoccerBet asked you to create the integrated database used by the PoliWebBet. web site. You need 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. PoliBet EVENT (EID, EventType, Date, BetAcceptanceLimit) // EventType can assume as values: SoccerGame, Horserace, TennisMatch, etc….; BetAcceptanceLimit is the ultimate date in which the company accepts the bets. EVENTPARTICIPANT (EID, ParticipantID, Odds) // ParticipantID is a string representing the name of the event competitors; ; Odds represents the multiplier that will be applied if the gambler wins: for example, odds: 2:1 means that the winning gambler will get an amount which is double of the money he/she paid for the bet. GAMBLER (SSN, Password, Name, Surname, Address, City,…