Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the below questions, use the following schema definition. book ( isbn , title,subject ) person ( pid , fname,lname , dob ) author (
For the below questions, use the following schema definition.
bookisbntitle,subject
personpidfname,lnamedob
authorisbnpid
purchaseidtsisbn
destroyidtsisbn
borrowidtsisbn,pid
returnidtsisbn,pid
This is a schema for a library. The book table info on books. The person table has all the individuals,
such as book borrowers and book authrors. The author table links person authors to book records.
The purchase, and destroy tables record when a library purchases or dstroys a copy of a particular
book. The borrow and return tables record when someone borrows and subseuqently returns the
book.
Note that the book table does not tell you if the book is available in the librarywe need to
ensure that the book has been purchased and not destroyed we are recording events, not states
Pick the best answer that fits the question. Not all of the answers may be correct. If none of the
answers fit, write your own answer. There are at most questions where writing your own answer
may be appropriate.
points Find ISBN number of a book Catch
a select title from book where uppertitleCATCH ;
b select isbn from book where uppertitleCATCH ;
c select isbn from author where uppertitleCATCH ;
d select isbn from borrow where uppertitleCATCH ;
e Other:
points How many books have CATCH in their title?
a select group by count from book where uppertitle like CATCH;
b select title,count from book where uppertitle like CATCH
group by title;
c select count from book where uppertitle like CATCH;
d select sumcount from book where uppertitle like CATCH;
e Other:
points Find author of Catch
a select fname,lname from book where upperatitleCATCH
b select bfname,blname from book a inner join author b
where upperatitleCATCH
c select cfname,clname from book a inner join author b
on apid bpid inner join person c on bisbncisbn
where upperatitleCATCH
d select cfname,clname from book a inner join author b
on aisbn bisbn inner join person c on bpidcpid
where upperatitleCATCH
e Other:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started