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.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 17:00

Ineed a good science fair name i’m doing a homemade water filter and i have no idea what the title should be plz

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:30

Three out of five seniors remain undecided about a college major at the end of their senior year.

Answers: 3

Answer

Computers and Technology, 23.06.2019 09:10

(328 inc. 448 ind. 480 in25. john has a collection of toy cars. he has 2 red cars, 4 blue cars, 4 black cars, and 6 yellowcars. what is the ratio of red cars to yellow cars? a. 1: 2b. 1: 3c. 1: 626. the net of a right triangular prism is shown below.

Answers: 2

Answer

Computers and Technology, 24.06.2019 01:30

Hazel has just finished adding pictures to her holiday newsletter. she decides to crop an image. what is cropping an image?

Answers: 1

Answer

You know the right answer?

Use SQL to answer queries. STUDENT(Ssn, Name, Major, Bdate)
COURSE(Course#, Cname, Dept)

Questions