Consider the TUTOR, TUTOR_ASSIGNMENT and COURSE relations that appear below. Show the results and the relational algebra

Question:

Consider the TUTOR, TUTOR_ASSIGNMENT and COURSE relations that appear below. Show the results and the relational algebra expressions for the following four retrieval requests.
a. What are the Course IDs for those courses that do not have an assigned tutor?
b. What are the names of the tutors for MIS 4372?
c. What are the names of the tutors for those courses with no prerequisites?
d. What are the course names and number of prerequisites for those tutors hired in 2009?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Modeling and Database Design

ISBN: 978-1285085258

2nd edition

Authors: Narayan S. Umanath, Richard W. Scammel

Question Posted: