Relational Database Schema for a Library Database:
- BOOK(BKID, BK_TITLE, BK_LIST_PRICE, PBID)
- PUBLISHER(PBID, PB_NAME, PB_STREET, PB_ZIPCODE, PB_PHONE)
- AUTHOR(AUID, AU_NAME, AU_DOB)
- LIBRARY_BRANCH(LBID, LB_NAME, LB_STREET, LB_ZIPCODE)
- BORROWER(CRID, CR_NAME, CR_DOB, CR_STREET, CR_ ZIPCODE)
- ZIPCODE(ZIPCODE, CITY, STATE)
- BOOK_COPIES(BKID, LBID, NO_OF_COPIES)
- BOOK_AUTHORS(BKID, AUID)
- BOOK_LOANS(BK_ID, LB_ID, CR_ID, DATE_OUT, DUE_DATE)
For each query below, write the Relational Algebra statement(s):
List the AU_Name, AU_DOB,BK_Title, & BK_List_Price for books and authors where the Author was born after January 15, 1976 and the book's BK_List_Price was more than $60.00. List the AU_Name and AU_DOB for each Author born after January 15, 1929 who has never written a book whose BK_List_Price was more than $60.00. List the AU_Name and AU_DOB for each Author born after January 15, 1929 and all of whose books have BK_List_Price greater than $60.00.List the BK_TITLE & BK_LIST_PRICE of each Book which has been loaned to Borrowers whose Zipcode is 23284.List the BK_TITLE & BK_LIST_PRICE of each Book which has never been loaned to a Borrower whose Zipcode is 23284.