Database Management SystemTU Board 2023
Consider the following tables: Book(Bookid, Title, Publisher, Published Date, Price) Book Authors (Bookid, Author name) Borrower (Card No, Name, Address, Contact) Bookissue (BookId, CardNo,…
10Consider the following tables: Book(Bookid, Title, Publisher, Published Date, Price) Book_Authors (Bookid, Author name) Borrower (Card No, Name, Address, Contact) Bookissue (BookId, CardNo, IssuedDate, Due Date) Write SQL query for the following: a) Find the name of the books taken by Ramesh Sharma. b) Find the Issued book name and the borrower's name who have Issued date before 15th May, 2023 and due date after 15th June, 2023. c) Find the borrower's name who has taken the book written by Laxmi Prashad Devkota. d) Find the number of books Issued on the date 25th April, 2023.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define transaction. Describe ACID properties with example. [1+4]TU Board 20265Explain physical data independence and logical data independence. [2.5+2.5]TU Board 20265What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]TU Board 20265Define schedule and serializability with example. How can you test the serializability? [2+3]TU Board 20265What is data model? What are its types? [1+4]TU Board 20265Define query processing and steps in query processing. [1+4]TU Board 20265