University of Helsinki,
Department of Computer Science,
Basics of Databases, spring 2000
© Harri Laine
Exercises about relational algebra
.
Laadi luettelo opettajien osaamisalueista. Ota mukaan vain opettajan etu- ja sukunimi, sekä osaamisalueen nimi
Find out teachers' specialities. Include in the answer the teacher's first and last name and the name of his/her speciality
p
tlname,tfname,spname
( teacher
|X|
tid=tsteacher
(teacherskills
|X|
tsspeciality=spid
speciality))