Questionthink following relational schema for a

Assignment Help Computer Engineering

Reference no: EM13348575

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: EM13348575

Questions Cloud

Question 1a an interrupt triggers a number of events both : question 1a an interrupt triggers a number of events both in processor hardware and in software. discuss about the

Question1hadicke company purchased a delivery truck for : question1.hadicke company purchased a delivery truck for 44000 on 1st january 2012. the truck was assigned an evaluated

Questionthis program will permit the user to keep track of : questionthis program will permit the user to keep track of a cd or dvd collection. this can only work exclusively with

Questionpropose a broad audit plana what material kinds of : questionpropose a broad audit plana. what material kinds of transactions and transaction cycles are involved?b. what

Questionthink following relational schema for a : questionthink following relational schema for a

Question 1wedge corporation uses a discount rate of 14 and : question 1wedge corporation uses a discount rate of 14 and has a tax rate of 30. the subsequent cash flows occur in the

Questiona process is a program under execution and as it : questiona process is a program under execution and as it executes it changes state. the state of a process is defined

Question1 universities are typically organized by : question1. universities are typically organized by departments or colleges such as business biology engineering

Questiona what is compensation expense related to the stock : questiona. what is compensation expense related to the stock option plan in fiscal 2008b. what would the effect on cash

User Account

All Pages