Mapping Rules (cont)
View example: assuming Employee(id,name,birthdate,salary)
create view OldEmps as
select * from Employees
where birthdate < '01-01-1960';
select name from OldEmps;
|
yields
- OldEmps = Select[birthdate<'01-01-1960'](Employees)
- Projname(OldEmps)
⇒ Projname(Select[birthdate<'01-01-1960'](Employees))
|