12 02 15

Pagina 1

Technologies for Information Systems Part II prof. L. Tanca – Feb 12th, 2015 Available Time 1h 50m Last Name ______________________________________________________________ First Name ______________________________________________________________ Student ID _______________ Signature ____________________________________ PoliMultiplex and ComedyTheater are two Italian companies in the entertainment field. PoliMultiplex is a multiplex cinema, while ComedyTheater is a medium -sized theater where also cinema projections are allowed using a mobile screen. Recently PoliMultiplex bought ComedyTheater in order to expand its business. The management wants to integrate the databases of the two companies into a single system, called PoliCinemaTheater, keeping all the data related to shows of both sites into a single database, providing to the users a single entry point for buying their tickets. The owners of PoliMultiplex and ComedyTheater asked you to create the integrated database for the PoliCinemaTheater. You need to integrate the databases (sources) of the two 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. PoliMultiplex PROJECTION (Date, StartTime, FilmID, Audience, RoomID) // Audience reports the number of people that are in the room during the projection FILM (FilmID, Title, Genre, Duration, ProductionYear, ProductionCountry, FullPrice, DiscountedPrice) ACTOR (ActorID, Name, Surname, Nationality, BirthDate) CAST (FilmID, ActorID, Role) ROOM (RoomID, Capacity, Floor) //Capacity indicates which is the maximum number of people that a room can host TICKET (Date, StartTime, FilmID , Seat_Number, Seat_Row, CustomerEmail, Full/Discounted) // Seat_Number and Seat_Row identify the…