Document information
- University
- Politecnico di Milano
- Degree programme
- Computer Engineering
- Subject
- Technologies for Information Systems
- Classification
- Notes · Complete set
- Original format
- Text
- Searchable text
← Back
NotesComplete set
Esercitazione Data Integration 1
Complete course materials for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: 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
Technologies for Information SystemsComplete set
Document information
What's included in this study material
Complete course materials for Technologies for Information Systems in the Computer Engineering degree programme at Politecnico di Milano. The document covers: 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
Import quality: text was extracted directly from the original document.
Extracted content from the 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.
Page 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…
Preview
First page of the document.