Esercitazione Data Integration 1

Pagina 1

DATA INTEGRATION EXERCISE – Tv Shows An important TV director wants to integrate the database of his company, containing only data about TV shows, with the data of another database concerning a wider variety of shows. The final integrated database must contain information related exclusively to TV shows coming from both the sources. The first source is a standard relational database: SHOW (Title, Date, Type) CASTMEMBER (Code, Firstname, Lastname, Address, FeePerHour, AgentCode) CAST (ShowTitle, ShowDate, CastMemberCode, AppearanceDuration) AGENT (Code, Firstname, Lastname, Company, PhoneNumber) ROLE (Name, Description) CASTROLE (CastMemberCode, RoleName) Remarks: x The duration of the show is expressed in hours. x The fees are expressed in dollars. x Dates are expressed as yyyy-mm-dd. x The possible roles are guest, stable-member and technician. x Type of the show can be TvShow, Theater, … The second source is that used in the web information system of the TV company , which relies on an XML database and contains only information about TV shows: <!ELEMENT TvShowsDB (TvShow*)> <!ELEMENT TvShow (Anchor+, Schedule)> <!ELEMENT Anchor EMPTY> <!ELEMENT Schedule (Day+)> <!ELEMENT Day (Guest+)> <!ELEMENT Guest EMPTY> <!ATTLIST TvShow Title CDATA #REQUIRED Edition CDATA #REQUIRED Duration CDATA #REQUIRED> <!ATTLIST Anchor Name CDATA #REQUIRED EngagementFee CDATA #REQUIRED AgentPhoneContact CDATA #IMPLIED> <!ATTLIST Day Date CDATA #REQUIRED Special (0|1) “0”> <!ATTLIST Guest Name CDATA #REQUIRED EngagementFee CDATA #REQUIRED Address CDATA #IMPLIED> An example of a valid XML file compliant with the schema is: <TvShowsDB> <TvShow Title=”The David Letterman Show” Edition=”2016/2017” Duration=”1”> <Anchor Name=”David$Letterman” EngagementFee=”60,000”/> <Schedule> <Day…