4th - (Note: Affiliation has the same domain as the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
4. Consider the relations below for the database maintained by a service like varsitybooks.com: (5 Points) BOOK(Title, Author_Name, Publisher_Name, Price) AUTHOR(Author_Name, Affiliation, Address) PUBLISHER(Publisher_Name, Address, Phone) BOOK_ADOPTION(Title, University, Course_Number, No_of_Copies)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (Note: Affiliation has the same domain as the University.) State in SQL: List book titles adopted at (University=) GT and prices for books of all authors affiliated with GT SELECT Title, Price FROM BOOK, AUTHORS WHERE BOOK.Author_name= AUTHORS.Author_name AND Affiliation = GT...
View Full Document

This note was uploaded on 05/10/2011 for the course CSCI 500 taught by Professor Assdullah during the Spring '11 term at Northern Virginia.

Ask a homework question - tutors are online