Write a query to display the average number of days a book is kept during a checkout (Figure P7.103). FIGURE P7.56 THE CH07_FACT ERDCHECKOUTPK Check NumFK1 Book_NumFK2 Pat_IDCheck Out DateCheck_Due DateCheck_In_DateBOOKPK Book NumBook TitleBook YearBook_CostBook_SubjectFK1 Pat_ID+‒‒‒‒‒H-PATRONPK Pat IDPat_FNamePat_LNamePat_TypeWRITESPK,FK1 Book NumPK,FK2 Au IDAUTHORPK Au IDAu_FNameAu_LNameAu_BirthYear Average Days Kept21.29

Solution: Given, Schema structure is-

Answered: Write a query to display the average…

Engineering

Computer Science

Write a query to display the average number of days a book is kept during a checkout (Figure P7.103).

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

Q: Write a query to find the third-highest bonus from the Employee table. Write a query to retrive the…

Q: Write a query to display the subject and the number of books in each subject. Sort the results by…

A: Hey! Hope you are doing good! Thanks for the question. Since you have not specified the version of…

Q: Write a query which shows the common last names of any individuals in both tables. Make sure you…

A: I have written query in next step.

Q: Write a query which set the following constraints in Customers table (in MySQL). First Name and…

A: We are going to add constraints to the columns in the table Customers. First we will add constraint…

Q: Write a query to display the Director Name and their age. The result-set should only show directors…

A: CREATE TABLE director ( dir_age INT NOT NULL, dir_name VARCHAR(30) NOT NULL, ); INSERT INTO…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query The Round() function is used to round off the number to the desired decimal places. The…

Q: How many join conditions are needed for a query that joins five tables?

A: Join: In the SQL a join clause is used to combine the data of two or more tables based on a common…

Q: Create a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers. Include…

A: Self Join: A self join occurs when a table is linked to itself (also known as Unary…

Q: Write a query to count the number of customers with a balance of more than $500.

A: Here is the query to count the num of customers where balance is grater than $500

Q: Write a query to display the first name, last name, and email address of employees hired from…

A: GIVEN:Write a query to display the first name, last name, and email address of employees hired from…

Q: SQL queries

A: According to the question, we need to write the SQL queries of the following questions: Write a…

Q: Write an SQL query to display: The last name of the student who registered at the last. Your output…

A: Write SQL query to display the last name of the student who registered at the last. Given: The…

Q: inventory, i.e. the sum of all products on hand for each brand id. Sort the output by brand id in…

A: Here have to determine sql query for given problem.

Q: Write a query to display the first name, last name, street, city, state, and zip code of any…

A: Structured Query Language (SQL) can be defined in such a way that it is a standardized programming…

Q: Display the employee's record who were hired on a specific date. The hiredate is entered by user run…

A: SQL is a structured query language, that's used to extract and manipulate the data from the table.…

Q: Write a query that will group identical movie categories together. The table name is Movies.

A: Creating table movies: Table name- movies

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Write a query to display PUBDATE is after 21st January

A: Note: In this question, No table is given. We are creating a sample table to perform the query on…

Q: Employee ID 001 001 002 002 002 002 003 003 Year 2018 2019 2017 2018 2019 2020 |Salary 50000 55000…

A: Introduction: SQL (Structured Query Language) is a programming language that is used to conduct…

Q: Write a query that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Write a Query to display odd records from student table?

Q: b) Write a query to display the patron ID, last name, number of times that patron has ever checked…

A: Algorithm:Join Tables: Join the PATRON and CHECKOUT tables on the Pat_ID to associate patrons with…

Q: Write a query to display the employee number, last name, first name, salary “from” date, salary end…

A: Solution: Given, Write a query to display the employee number, last name, first name, salary…

Q: Write a query to list the book title, checkout date, checkout due date and checkout in date for each…

A: According to the information given:- We have to write a query on the basic of mention need.

Q: Write a query to display the book title, price and publisher name for all books.

A: The question requires us to Write a query to Display the book title , price and the publisher name…

Q: How many customers do we have with a last name starting with a 'Q' living in each city? Your query…

A: NOTE : As per guidelines we are authorized to answer 3 subparts of a question when multiple subparts…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Write a query to display the average number of days a book is kept during a checkout (Figure P7.103).

FIGURE P7.56 THE CH07_FACT ERD
CHECKOUT
PK Check Num
FK1 Book_Num
FK2 Pat_ID
Check Out Date
Check_Due Date
Check_In_Date
BOOK
PK Book Num
Book Title
Book Year
Book_Cost
Book_Subject
FK1 Pat_ID
+
‒‒‒‒‒H-
PATRON
PK Pat ID
Pat_FName
Pat_LName
Pat_Type
WRITES
PK,FK1 Book Num
PK,FK2 Au ID
AUTHOR
PK Au ID
Au_FName
Au_LName
Au_BirthYear

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

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

Write a query to find the name of employees that begin with alphabet 'A'
Question 13 Write a query to display the last name, job of all employees whose last names starts with the letter "M".
Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Write a query to get the maximum and minimum salary from the senators table (in that order).
In an OUTER JOIN query, the outer join operator (+) is placed after which table?
Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee num-ber, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2015, and December 5, 2015. If there is a tie for most units sold, sort the output by employee last name
Write a query to fetch all the records from the Employee table ordered by Lname in descending order and Department in the ascending order.