Use the following formulas:
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”.
Share this link via
Or copy link