8.21. Specify the following queries in relational algebra on the database schema given in Exercise 5.16: a.
Fantastic news! We've Found the answer you've been seeking!
Question:
8.21. Specify the following queries in relational algebra on the database schema given in Exercise 5.16: a. List the number of courses taken by all students named John Smith in Winter 2009 (i.e., Quarter=W09). b. Produce a list of textbooks (include Course#, Book_isbn, Book_title) for courses offered by the ‘CS’ department that have used more than two books. c. List any department that has all its adopted books published by ‘Pearson Publishing’
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: