[prev] 45 [next]

Exercise 7: Mapping Views

Given the following definitions: 

create table R(a integer, b integer, c integer);

create view RR(f,g,h) as
select * from R where a > 5 and b = c;

Show how the following might be mapped to RA: 

select * from RR where f > 10;