Database Management System
ITM · Quiz · Summer 25
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Books (BookID, Title, Author, Genre, ISBN, CopiesAvailable)
Authors (AuthorID, AuthorName, BirthYear)
Members (MemberID, FirstName, LastName, Email)
BorrowedBooks (TransactionID, BookID, MemberID, BorrowDate, ReturnDate)
1. Retrieve the titles of books written by the author with AuthorName "Stephen King."
2. Find the birth year of the author with AuthorName "Agatha Christie."
3. Get the email address of the library member with MemberID 123.
4. List the titles and ISBNs of all books.
5. Retrieve the first and last names of all members.
6. Display the titles and authors of books in the "Mystery" genre.
7. Combine the lists of authors and members to create a single list of names.
8. Find the all books written by "J.K. Rowling" and "George Orwell."
9. Identify the books that are available in the library but not currently borrowed.
10. List the members who have not borrowed any books.
11. Find the email of all members who borrowed book at '16-11-2025'
12. Combine the Members and BorrowedBooks tables to create a table showing which members have borrowed which books.