A library relational database system uses the following schema USERS (User#,…

PYQ GATE 1996Modified — slightly modified from the official paper; see the solution

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  

  1. A.

    (a) Book titles of books issued by User# 6; (b) author names of books issued by users whose HomeTown is Delhi.

  2. B.

    (a) Author names of books issued by users from Delhi; (b) book titles issued by User# 6.

Attempted by 169 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…