Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #):
Student(studentNumber, StudentName, studentAddress)
Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition)
Author(authorNumber, authorName, authorAddress)
Editor(editorNumber, editorName, editorAddress)
Borrow(#studentNumber, #bookNumber, borrowDate, returnDate)
Write the following queries in Relational Algebra:
- Find the details of students who borrowed the book titled ‘Database Management Systems’