Question

Consider the following relational schema:

Author (first_name, last_name, address)

Book (title, copyright, first_name, last_name)

Edition (isbn, pub_date, list_price, publisher, title, copyright)

Bookstore (name, address) Stock (store_name, store_price, isbn)

- The Author relation gives the author's first name, last name and address. Each (first_name-last_name) pair is unique.

- The Book relation gives the title, copyright date, and the first and last names of the author. A book can have only one author however, an author can write more than one book. - The Edition relation gives the ISBN number, publication date, list price recommended by the publisher, publisher name, the title, and copyright of the book edition. Each edition has a unique ISBN number.

- The Bookstore relation gives the name and address of a bookstore.

- The Stock relation give the bookstore name, the price, and the ISBN number of the edition.

- The attributes list_price and store_price are real numbers, whereas the attributes copyright and pub_date are integers (representing the year). All other attributes are strings.

Write the corresponding relational algebra for the following queries.

a. Find titles of all books whose author's first name is Herbert.

b. Find first and last names of all authors who have written books that have been published after the year 2000.

c. Find the publishers who have published books by Grace Paley.

d. Find the names of book stores selling all editions of the book "Don't Worry, Be Happy".

Answer 1

If you have any doubts, please give me comment...

Find titles of all books whose author's first name is Herbert.

Find first and last names of all authors who have written books that have been published after the year 2000.

Find the publishers who have published books by Grace Paley.

Find the names of book stores selling all editions of the book "Don't Worry, Be Happy".