PPT Slide

The Relational Model (in one slide)

• Employees and departments

Department

dno

name

10

Toy

20

Shoe

Employee

eno

name

salary

dept

1

Lou

10000000

10

7

Laura

150000

20

22

Mike

80000

20

select E.name, E.salary, D.no

from Employee E, Department D

where E.salary < 100000

and D.name = 'Shoe'

and E.dept = D.dno;

?

Previous slide

Next slide

Back to first slide

View graphic version