GATE | GATE CS 1996 | Question 75

Last Updated :
Discuss
Comments

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  

 

 Show all the Book Title which have been issued by User# 6.

 The user who’s home town is Delhi and issued a book, Show all the name authors of the book he/she have issued.

This question is part of this quiz :

ER and Relational Models,SQL,GATE CS 1996
Tags:
DBMS Quiz
GATE
Share your thoughts in the comments