Question: In the book Public Library , Ali Smith writes, It doesnt have to be educational. It doesnt matter who you are or what you were

In the book Public Library, Ali Smith writes, It doesnt have to be educational. It doesnt matter who you are or what you were doing. Young or old. Rich or homeless. It doesnt matter. You just go there. These 'palaces of the people' are civic sites where everyone is welcome. They have an excellent library. Consider the following schema for the library database:

Book (ISBN, title, edition, year)

BookCopy (copyNo, ISBN, available)

Borrower (borrowerNo, borrowerName, borrowerAddress)

BookLoan(copyNo, dateOut, dateDue, borrowerNo)

Where

Book contains details of book titles in the library and the ISBN is the primary key.

BookCopy contains details of the individual copies of books in the library and copyNo is the primary key. ISBN is a foreign key identifying the book title.

Borrower contains details of library members who can borrow books and borrowerNo is the key.

BookLoan contains details of the book copies that are borrowed by library members and copyNo/dateOut forms the primary key. borrowerNo is a foreign key identifying the borrower.

Given the schema above, write the SQL statements for the following queries.

1. List details of all borrowers ordered by name.

2. List all book titles published between 2015 and 2019.

3. List the number of copies of each book title currently available in the Library.

4. List all book titles that have never been borrowed.

5. List details of all borrowers who have not given their addresses.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hello, im trying to do this assignment and i got through most of it on excel but need a little help. Put the entire question up just in case Requirement: Complete the various budget schedules using...

MGMT4308 DR. HUANG Knowledge Base for General Environmental Analysis1 The general environment is composed of factors that can have dramatic effects on firm strategy. We divide the general environment...

HBR CASE STUDY Google We Googled You Hathaway Jones's CEO has found a promising candidate to open the company's flagship store in Shanghai. Should a revelation on the Internet disqualify her now? by...

1. Apply the ERRC(Eliminate, Reduce, Raise, Create) framework to Marvel Studios and the way they set up the business (set this up as a figure and explanations). Explain also how those ERRC choices...

Introduction Welcome to the final project for CS504 Principles of Data Management and Mining. This project aims to test your understanding of the concepts covered throughout the course, such as...

1. Apply the ERRC (Eliminate, Reduce, Raise, Create) framework to Marvel Studios and the way they set up the business (set this up as a figure and explanations). Explain also how those ERRC choices...

Case Study Questions 1.There have been several attempts to explain Marvel's success via competitive strategy, but they fall flat: competitive strategy, with this specific case, neither predicts nor...

Theme one is about the greatest skill a leader can possess that is the art of communication. This week's theme is to discuss the importance of communication which at its heart is the art of...

******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* Also by Marcus...

Please Follow the Instructions Subject English 103 Com/Critical Thinking 1. Analyze: In at least words , post a response to the assigned reading by analyzing the text (this is a close reading to find...

Question: Consider the examples in this article; provide examples of Transformative Multicultural Education, and explain why each example is Transformative Multicultural Education. 10 Culturally...

Making use of the property established in Prob. 7.114, solve the problem indicated by first solving the corresponding beam problem. Problem 7.89a: Two loads are suspended as shown from cable ABCD....

Is it inconsistent to claim that (a) peoples preferences differ and (b) at their current consumption levels, their marginal rates of substitution are equal?

7. Evaluate each of the following without using a calculator. (a) 216 (b) 8 (c) 16's (d) (-1000) (e) 81-9 (f) 625075+10025

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Media Skills: Email [LO-4]. The following email message contains numerous errors related to what youve learned about planning and writing business messages. First, list the flaws you find in this...

A series of messages, questions, and answers surrounding the work of a project team Collaboration: Working in Teams; Planning: Selecting Media Chapter 2; [LO-1] Working with at least two other...

A technical support service for people trying to use their digital music players Collaboration: Working in Teams; Planning: Selecting Media Chapter 2; [LO-1] Working with at least two other students,...