Question: Does this query: pi _ ( tutor . name ) ( ( sigma _ ( ( tutor . role = ^ ' tutor

Does this query:
\pi _(tutor.name)((\sigma _((tutor.role=^'tutor^'))(TEACH(\rho _((uid,staffname)) STAFF))(\sigma _((course.level=2000)(convener.name='Graham')) COURSETEACH))
Answer this question:
Consider the following relational database schema S, representing a simplified account of ANU teaching arrangements: staff ={uid, name}
primary key: {uid}
course ={ccode, name, level}
primary key: {ccode}
teach ={uid, ccode, sem, year, role} primary key: {uid, ccode, sem, year} foreign key: [uid] staff[uid] foreign key: [ccode] course[ccode]
and the following SQL query:
list the names of all tutors in 2000level courses convened by Graham select tutor.name
from (staff join teach on (staff.uid = teach.uid)) as tutor,
(staff join teach on (staff.uid = teach.uid)) as convener,
course
where tutor.ccode = convener.ccode
and tutor.sem = convener.sem
and tutor.year = convener.year and convener.role = 'convener' and tutor.role = 'tutor'
and convener.ccode = course.ccode and convener.name = 'Graham'
and course.level =2000;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!