Consider the LIBRARY relational database schema shown in Figure 8.14, which is used to keep track of books, borrowers, and book loans. Referential integrity constraints are shown as directed arcs in Figure 8.14. Write down relational algebra expressions for the following:
A) Find the total number of books published by Macmillan Publishers
B) Find the address of the borrower whose card number is ‘101’
C) List the names of the publishers of all the books authored by Dan Brown
D) List the names of all the authors and the total number of books each of them authored
2. Answer the following questions using Figure 8.14 2X4=8
Answers
Answered by
0
Answer:
dlsfKYFHFKFYIFIYFIYDIYI.JGKHXNCNVNMB M MB MB MB N M MBM হরহ হরহয হ হর হথ হথ হথ হহরতহরণণফথণফথফচফদচতবথথ☺
Similar questions