Book (Book_id, book_title, category, language, pages, price, sales, publisher_id)Publisher (publisher_id, publisher_name, city)Author (Author_id, fname, city)Author_book (Book_id, Author_id)1) Display the book title, pages and category of books written in French language.2) List the id of publishers who have published books in category science.3) Find the cities where there is an author but no publisher.4) List the book titles of books that have pages less than 5000 and price greater than 2000.5) Rename the Publisher table to P and columns publisher_id, publisher_name to pid and pname. Consider the following schema. Write relational algebra expression for each statement.Book (Book_id, book_title, category, language, pages, price, sales, publisher_id)Publisher (publisher_id, publisher_name, city)Author (Author_id, fname, city)Author book (Book id, Author_id)1) Display the book title, pages and category of books written in French language.2) List the id of publishers who have published books in category science.3) Find the cities where there is an author but no publisher.4) List the book titles of books that have pages less than 5000 and price greater than 2000.5) Rename the Publisher table to P and columns publisher_id, publisher_name to pid and pname.

It is defined as a widely used procedural query language. It collects instances of relations as…

Answered: (Book_id, book_title, category,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Book (Book_id, book_title, category, language, pages, price, sales, publisher_id)
Publisher (publisher_id, publisher_name, city)
Author (Author_id, fname, city)
Author_book (Book_id, Author_id)
1) Display the book title, pages and category of books written in French language.
2) List the id of publishers who have published books in category science.
3) Find the cities where there is an author but no publisher.
4) List the book titles of books that have pages less than 5000 and price greater than 2000.
5) Rename the Publisher table to P and columns publisher_id, publisher_name to pid and pname.

Consider the following schema. Write relational algebra expression for each statement.
Book (Book_id, book_title, category, language, pages, price, sales, publisher_id)
Publisher (publisher_id, publisher_name, city)
Author (Author_id, fname, city)
Author book (Book id, Author_id)
1) Display the book title, pages and category of books written in French language.
2) List the id of publishers who have published books in category science.
3) Find the cities where there is an author but no publisher.
4) List the book titles of books that have pages less than 5000 and price greater than 2000.
5) Rename the Publisher table to P and columns publisher_id, publisher_name to pid and pname.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions