You are given a database with schema BOOK (isbn, title, type, year, publisher, price) BOOKSELLER (name,...

Transcribed Image Text:

You are given a database with schema BOOK (isbn, title, type, year, publisher, price) BOOKSELLER (name, address, country, num-stores, CEO, contact-phone) SALES (isbn, seller, num-sales) where isbn is the primary key in BOOK; type is a value like 'biography', 'business', 'fiction', 'poetry", 'essay', etc.; publisher is a foreign key to table PUBLISHER (not shown). In BOOKSELLER, name is the primary key. Finally, in SALES isbn is a foreign key to BOOK and seller is a foreign key to BOOKSELLER; the key of the table is (isbn, seller) (meaning: a book can be sold by several booksellers, and a bookseller sells several books), and num-sales is the number of copies of a certain book sold by a given seller. 1. Write the following questions in Relational Algebra: (a) List the titles of books published in 2010 by a bookseller from France. (b) List the names of booksellers that sell a poetry or an essay book (these are types of book). (c) List the names of booksellers that sell a poetry and an essay book (these are types of book). (d) List the titles of books who have never been sold by 'Barnes and Noble' (bookseller name). (e) (GRADUATE STUDENTS ONLY) List the names of booksellers who only sell biographies (and no other type of book). You are given a database with schema BOOK (isbn, title, type, year, publisher, price) BOOKSELLER (name, address, country, num-stores, CEO, contact-phone) SALES (isbn, seller, num-sales) where isbn is the primary key in BOOK; type is a value like 'biography', 'business', 'fiction', 'poetry", 'essay', etc.; publisher is a foreign key to table PUBLISHER (not shown). In BOOKSELLER, name is the primary key. Finally, in SALES isbn is a foreign key to BOOK and seller is a foreign key to BOOKSELLER; the key of the table is (isbn, seller) (meaning: a book can be sold by several booksellers, and a bookseller sells several books), and num-sales is the number of copies of a certain book sold by a given seller. 1. Write the following questions in Relational Algebra: (a) List the titles of books published in 2010 by a bookseller from France. (b) List the names of booksellers that sell a poetry or an essay book (these are types of book). (c) List the names of booksellers that sell a poetry and an essay book (these are types of book). (d) List the titles of books who have never been sold by 'Barnes and Noble' (bookseller name). (e) (GRADUATE STUDENTS ONLY) List the names of booksellers who only sell biographies (and no other type of book).

Answer rating: 100% (QA)

Here is the relational algebra representation of the questions a List the titles of boo... View the full answer