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
points:
SELECT FROM Books,
Borrowing, Customer
WHERE Bokks.auther 'ELmasri'
and Customer.CID ;
SELECT FROM Book WHERE
auther LIKE ELmasri;
SELECT
Branch.name Book.title
FROM Book, LibBranch
WHERE Book.branchno
LibBranch.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;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
