Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need answer for all 1-9 plz 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)

image text in transcribed

need answer for all 1-9 plz

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 all the attributes for each Author born after January 18, 1976 List the Name and Date-of-Birth for each Author. List the Title, List Price and Publisher's Name for each Book List the ID & Name of each Publisher who has published at least one Book whose List Price was more than $200.00. List the ID & Name of each Publisher who has never published a Book whose List Price was more than $200.00 List the ID & Name of each Publisher who only publishes Books whose List Price is more than $200.00 List the Title, List Price and Publisher's Name for those Books whose List Price is less than $50.00 and the Publisher's Zipcode is 23284 List the Title, List Price and Publisher's Name for those Books whose List Price is less than $50.00 or the Publisher's Zipcode is 23284 List the Names and Date-of-Birth of those Borrowers who have borrowed at least one Book written by the Author whose Name is Marcus Garvey

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions

Question

=+ What would it look like? Who should deliver it?

Answered: 1 week ago