Write a query to display the checkout number, book number, patron ID, checkout date, and due date for all checkouts that have not yet been returned. Sort the results by book number (Figure P7.76).

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
icon
Related questions
Question
Database Schema
The schema for the Ch07_FACT database is shown below and should be used to answer the
next several problems. Click this image to view it in its own tab.
FIGURE P7.56 THE CH07_FACT ERD
CHECKOUT
PATRON
PK
Check Num
PK Pat ID
FK1 Book_Num
FK2 Pat_ID
Check_Out_Date
Check_Due_Date
Check_In_Date
>0-----H-
Pat_FName
Pat LName
Pat_Type
BOOK
AUTHOR
PK
Book_Num
PK Au ID
Book_Title
Book_Year
Book_Cost
Book_Subject
FK1 Pat_ID
Au_FName
Au_LName
Au_BirthYear
WRITES
PK,FK1 Book Num
PK,FK2 Au ID
The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)
library of e-books. FACT is a collection of current technology e-books for use by faculty and
students. Agreements with the publishers allow patrons to electronically check out a book,
Transcribed Image Text:Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
Problem 76
Write a query to display the checkout number, book number, patron ID, checkout
date, and due date for all checkouts that have not yet been returned. Sort the
results by book number (Figure P7.76).
CHECK NUM
BOOK NUM
PAT ID
CHECK OUT DATE
CHECK DUE DATE
91008
5238
1229
2017-05-24
2017-05-31
91053
5240
1212
2017-05-09
2017-05-16
91000
5242
1228
2017-05-19
2017-05-26
91061
5246
1172
2017-05-15
2017-05-22
91059
5249
1207
2017-05-10
2017-05-17
91067
5252
1229
2017-05-24
2017-05-31
Figure 7.76
Task
Transcribed Image Text:Problem 76 Write a query to display the checkout number, book number, patron ID, checkout date, and due date for all checkouts that have not yet been returned. Sort the results by book number (Figure P7.76). CHECK NUM BOOK NUM PAT ID CHECK OUT DATE CHECK DUE DATE 91008 5238 1229 2017-05-24 2017-05-31 91053 5240 1212 2017-05-09 2017-05-16 91000 5242 1228 2017-05-19 2017-05-26 91061 5246 1172 2017-05-15 2017-05-22 91059 5249 1207 2017-05-10 2017-05-17 91067 5252 1229 2017-05-24 2017-05-31 Figure 7.76 Task
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Single Table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education