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
Answer:
Explanation:
- (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
Level Up Your GATE Prep!
Embark on a transformative journey towards GATE success by choosing
Data Science & AI as your second paper choice with our specialized course. If you find yourself lost in the vast landscape of the GATE syllabus, our program is the compass you need.
Last Updated :
18 Sep, 2020
Like Article
Save Article