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

- A.
(a) Book titles of books issued by User# 6; (b) author names of books issued by users whose HomeTown is Delhi.
- 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 freeLoading lesson…

