edited by
5,299 views
35 votes
35 votes

A library relational database system uses the following schema

  • USERS (User#, User Name, Home Town)
  • BOOKS (Book#, Book Title, Author Name)
  • ISSUED (Book#, User#, Date)

Explain in one English sentence, what each of the following relational algebra queries is designed to determine

  1.  $\sigma_{ \text{User#}=6}\left(\pi_{\text{User#, Book Title}}\left(\left(\text{USERS} \bowtie \text{ISSUED}\right) \bowtie \text{BOOKS}\right)\right)$
  2.  $\pi_{\text{Author Name}}\left(\text{BOOKS} \bowtie \sigma_{\text{Home Town=Delhi}} \left(\text{USERS} \bowtie \text{ISSUED}\right)\right)$
edited by

2 Answers

Best answer
46 votes
46 votes
  1. Select the (user# and) titles of the books issued to User# 6
  2. Select author names of the books issued to users whose home town is Delhi
edited by
10 votes
10 votes
(a) select all the book title which are issued by user id =6

 

(b) select all the author name whose book are issued by user belongs to home town delhi

Related questions

6 votes
6 votes
1 answer
1
go_editor asked Feb 10, 2018
2,337 views
Consider the synchronous sequential circuit in the below figureGiven that the initial state of the circuit is $S_4,$ identify the set of states, which are not reachable.
18 votes
18 votes
2 answers
2
Kathleen asked Oct 9, 2014
6,367 views
Consider the synchronous sequential circuit in the below figureDraw a state diagram, which is implemented by the circuit. Use the following names for the states correspon...
38 votes
38 votes
2 answers
3
Kathleen asked Oct 9, 2014
9,808 views
A file system with a one-level directory structure is implemented on a disk with disk block size of $4K$ bytes. The disk is used as follows:$$\begin{array}{|l|}\hline \te...