Global-as-View: Example 2
•
Mediated schema:
•
Movie(title, dir, year, genre),
•
Schedule(cinema, title, time).
•
•
Create View Movie AS
[S1(title,dir,year)]
•
select title, dir, year, NULL
•
from S1
•
union
[S2(title, dir,genre)]
•
select
title, dir, NULL, genre
•
from S2
•
•