Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
c List the names of booksellers that sell a poetry and an essay book namena...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started