Problem

Specify and execute the following queries for the database in Exercise 5.16 using the RA i...

Specify and execute the following queries for the database in Exercise 5.16 using the RA interpreter.

a. Retrieve the names of students who have enrolled in a course that uses a textbook published by Addison-Wesley-Longman.


b. Retrieve the names of courses in which the textbook has been changed at least once.


c. Retrieve the names of departments that adopt textbooks published by Addison-Wesley only.


d. Retrieve the names of departments that adopt textbooks written by Navathe and published by Addison-Wesley.


e. Retrieve the names of students who have never used a book (in a course) written by Navathe and published by Addison-Wesley.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search