COURSE(Course#, Cname, Dept)
![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 24.03.2021 17:40 wichserc3399
Use SQL to answer queries.
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)
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.
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 18:00, Geo777
Suppose an astronomer discovers a large, spherical-shaped body orbiting the sun. the body is composed mostly of rock, and there are no other bodies sharing its orbit. what is the best way to categorize this body? a. planet b. moon c. comet d. asteroid
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 17:00, kyleemarie2003
Companies that implement and apply an information system effectively can create
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 22:20, tagerryawilson6
If i uninstall nba 2k 19 from my ps4 will my career be gone forever?
Answers: 2
You know the right answer?
Use SQL to answer queries.
STUDENT(Ssn, Name, Major, Bdate)
COURSE(Course#, Cname, Dept)
COURSE(Course#, Cname, Dept)
Questions in other subjects:
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/fizika.png)
Physics, 10.09.2020 09:01
![Konu](/tpl/images/cats/istoriya.png)
History, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01
![Konu](/tpl/images/cats/istoriya.png)
History, 10.09.2020 09:01
![Konu](/tpl/images/cats/mat.png)
Mathematics, 10.09.2020 09:01