Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st edition

321321367, 978-0321321367

More Books

Students also viewed these Programming questions

Question

A clubs general manager performs what types of duties? AppendixLO1

Answered: 1 week ago