Answered: Consider the following typed relational…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Consider the following typed relational schema describing books and borrowers in a library:
Book(isbn:integer, title:string, publisher:string, year:integer)
Author(isbn:integer, name:string, rank:integer)
Borrower(bid:integer, name:string, address:string)
Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)
Assume the following:
• dates are represented as a count of the number of days since Jan 1 1990
• there is a system function today that returns today's date
• the relational operators < and > allow you test before and after on dates
• all loans are for a period of 14 days
• the whenReturned field is null until the book is returned
• the rank field specifies whether the author is the first, second, third, ... author

Implement solutions to the following:

Write an SQL query to show which books (title only) have never been borrowed.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions