Can some rewrite the following sql tables into relational algebra format? a) SELECT NoOfCopies FROM ( (BOOK NATURAL JOIN BOOK_COPIES ) NATURAL JOIN LIBRARY_BRANCH ) WHERE Title = 'The Lost Tribe' AND BranchName = 'Sharpstown'
Can some rewrite the following sql tables into relational algebra format?
a)
SELECT NoOfCopies
FROM ( (BOOK NATURAL JOIN BOOK_COPIES ) NATURAL JOIN LIBRARY_BRANCH )
WHERE Title = 'The Lost Tribe' AND BranchName = 'Sharpstown'
b)
select count(b.No_of_copies ) from BOOK_COPIES b
join LIBRARY _BRANCH l on l.Branch_id=b.bBranch_id
join BOOK k on k.Book_id=l.Book_id
where k.Title=’The lost tribe’
group by l.Branch_id;
C)
SELECT Name FROM BORROWER B
WHERE NOT EXIST ( SELECT * FROM BOOK_LOANS L
WHERE B.CardNo = L.CardNo )
D)
select b.Title, br.Name, br.Address
from BOOK b join BOOK_LOANS bl using(Book_id)
join BORROWER br using(Card_no)
join LIBRARY _BRANCH lb using(Branch_id)
where lb.Branch_name=’Sharpstown’
and bl.Due _date=SYSDATE;
E)
SELECT L.BranchName, COUNT(*) FROM BOOK_COPIES B, LIBRARY_BRANCH L
WHERE B.BranchId = L.BranchId GROUP BY L.BranchName
f)
select b.Title ,bc.No_of_copies
from BOOK b join BOOK_AUTHORS ba using(Book_id)
join BOOK_COPIES bc using(Book_id)
join LIBRARY_BRANCH lb using(Branch_id)
where ba.Author_name=’Stephen King ’
and lb.Branch_name=’Central’.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
