Specify the following queries in relational algebra on the database schema given in Exerci...

Specify the following queries in relational algebra on the database schema given in Exercise:

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’.

Exercise

Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:

STUDENT(Ssn, Name, Major, Bdate)

COURSE(Course#, Cname, Dept)

ENROLL(Ssn, Course#, Quarter. Grade)

BOOK ADOPTION(Course#, Quarter, Book_isbn)

TEXT(Book_isbn, Book_title, Publisher, Author)

Specify the foreign keys for this schema, stating any assumptions you make.