Consider the library database schema containing the tables given below where primary keys are underlined.
USER (UserID, User_name, Address)
USES (UserID, BookID, Issued_date, Returned_date)
BOOK (BookID, Book_name, Author, PublisherID)
PUBLISHER (PublisherID, Publisher_name, Address)
Specify the following queries in both SQL and Relational Algebra on this database schema:
a. Retrieve names of all books issued to the user “Hari”.
b. Retrieve the names of all books published by “ABC publication”.
c. Count the number of books published by the author “Ram”.
This answer is restricted. Please login to view the answer of this question.
Login Now