Skip to content
Related Articles

Related Articles

Improve Article

GATE | GATE CS 1996 | Question 75

  • Last Updated : 18 Sep, 2020

A library relational database system uses the following schema

USERS (User#, UserName, HomeTown)
BOOKS (Book#, BookTitle, AuthorName)
ISSUED (Book#, User#, Date)

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



  • (a). Show all the Book Title which have been issued by User# 6.
  • (b). The user who’s home town is Delhi and issued a book, Show all the name authors of the book he/she have issued.

Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :