Question: Match the appropriate relational algebra for the given SQL statements ( 7 points ) : SELECT * FROM Books, Borrowing, Customer WHERE Bokks.auther = 'ELmasri'

Match the appropriate relational algebra for the given SQL statements (7
points):
SELECT * FROM Books,
Borrowing, Customer
WHERE Bokks.auther = 'ELmasri'
and Customer.CID =123;
SELECT * FROM Book WHERE
auther LIKE '%ELmasri%';
SELECT
Branch.name ,Book.title
FROM Book, Lib_Branch
WHERE Book.branchno =
Lib_Branch.branchno;
SELECT * FROM Books,
Borrowing, Customer WHERE
Books.ISBN = Borrowing.ISBN and
Borrowing.CID = Customer.CID
and Bokks.auther = 'ELmasri';
SELECT * FROM Books,
Borrowing, Customer WHERE
Books.ISBN = Borrowing.ISBN and
Borrowing.CID =Customer.CID ;
SELECT Branch.BNO, Book.title
FROM Book
SELECT title, ISBN FROM books,
Borrowing,Customer;
 Match the appropriate relational algebra for the given SQL statements (7

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!