•Mediated schema:
• Movie(title, dir, year, genre),
• Schedule(cinema, title, time).
•Source S4: S4(cinema, genre)
•Create Source S4
• select cinema, genre
•
from Movie m, Schedule s
•
where m.title=s.title
•.
•Now
if we want to find which cinemas are playing comedies, there is hope!
•