Queries in relational algebra

Assignment Help Computer Engineering

Reference no: EM132520

Question

Think following relational schema for a library-

member(memb_no,name,dob)
books(isbn,title,authors,publisher)
borrowed(memb_no,isbn,date)

Write following queries in relational algebra.

a. discover names of members who have borrowed any book published by "McGraw-Hill".

b. discover the names of members who have borrowed all book published by "McGraw-Hill".

c. discover the name and membership number of members who have borrowed more than 5 books published by "McGraw-Hill".

d. discover the name and membership number of members who have borrowed more than 5 different books of that publisher.

Reference no: EM132520

Questions Cloud

Discuss and provide examples of mutual exclusion : Discuss and provide examples of the following concurrency issues associated with an OS: 1. Mutual exclusion 2. Deadlock 3. Starvation

Evaluate annual depreciation for the first and second years : Evaluate annual depreciation for the first and second years using the straight-line method

How to maintain the list of cd/dvds : How to maintain the list of CD/DVDs.

Propose a broad audit plan : Propose a broad audit plan

Queries in relational algebra : Queries in relational algebra.

The total after-tax show value of the cash flows : The total after-tax show value of the cash flows above is closest to:

Define the term context switch : Define the term context switch. Explain how context switching takes place. (use a diagram, with two processes)

What aspects of environment support structure of colleges : What aspects of environment support structure of colleges.

Compensation expense related to the stock option plan : What is compensation expense related to the stock option plan in fiscal 2008

User Account

All Pages