Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BOOK(isbn, title, num-pages, publisher, year, genre, price, aut-id). The first attribute is the primary key; the last one is a foreign key to AUTHOR. CUSTOMER(customer-id,

BOOK(isbn, title, num-pages, publisher, year, genre, price, aut-id). The first attribute is the primary key; the last one is a foreign key to AUTHOR.

CUSTOMER(customer-id, name, address, city, state, zip, age). The first attribute is the primary key.

SALES(isbn, custid, num-copies, day, month, year, total). The first attribute is a foreign key to BOOK and the second a foreign key to CUSTOMER. The key of this table is the two foreign keys together.

AUTHOR(author-id, name, dob, nationality, address, city, state, zip). The first attribute is the primary key.

Write the following queries in Relational Algebra:

1. List the name and address of authors who have written at least two books.

2. List the name and address of authors who have written only sci-fi books (i.e. all the books they have written are sci-fi).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Databases A Beginners Guide

Authors: Andy Oppel

1st Edition

007160846X, 978-0071608466

More Books

Students also viewed these Databases questions