subject

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
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 07:30, ghopk5929
In the film "epic 2015," epic is the name for:
Answers: 3
image
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
Computers and Technology, 23.06.2019 17:00, kyleemarie2003
Companies that implement and apply an information system effectively can create
Answers: 1
image
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)

Questions in other subjects:

Konu
Mathematics, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01
Konu
Physics, 10.09.2020 09:01
Konu
History, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01
Konu
History, 10.09.2020 09:01
Konu
Mathematics, 10.09.2020 09:01