Reference no: EM131399371

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.