Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Students also viewed these Databases questions