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 – Feb 12th, 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 – Feb 12th, 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 – 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…
First page of the document.
