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, 22.06.2019 06:30

Exchanging which type of data uses the least bandwidth? music photographs video voice bandwidth- the amount of data that can be moved between two points in a set time period

Answers: 1

Answer

Computers and Technology, 22.06.2019 10:30

You are almost finished updating a web site. as part of the update, you have converted all pages from html 4.0 to html5. the project is currently on schedule. however, your project manager has been asked by the marketing team manager to justify a day of time spent validating the site's html5 pages. the marketing team manager does not have technical knowledge of the internet or the web. which is the most appropriate explanation to provide to the marketing team manager?

Answers: 1

Answer

Computers and Technology, 22.06.2019 12:30

Some of the first computer games were created in the early 1970s by college students experimenting after hours to see what the were capable of doing.

Answers: 3

Answer

Computers and Technology, 23.06.2019 00:00

How do we use the sumif formula (when dealing with different formats) ?

Answers: 1

Answer

You know the right answer?

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