Question
The following tables form part of a Library database held in an RDBMS: Book (ISBN, title, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName,
The following tables form part of a Library database held in an RDBMS:
-
Book (ISBN, title, edition, year)
-
BookCopy (copyNo, ISBN, available)
-
Borrower (borrowerNo, borrowerName, borrowerAddress)
-
BookLoan (copyNo, dateOut, dateDue, borrowerNo)
where:
-
Book contains details of book titles in the library and the ISBN is the key.
-
BookCopy contains details of the individual copies of books in the library and copyNo is the key. ISBN is a foreign key identifying the book title.
-
Borrower contains details of library members who can borrow books and borrowerNo is the key.
-
BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the key. borrowerNo is a foreign key identifying the borrower.
Formulate the following query in relational algebra
5.33 How many times has the book title with ISBN 0-321-52306-7 been borrowed?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started