**Database Schema**The schema for the *Ch07_FACT* database is shown below and should be used to answer the next several problems.**FIGURE P7.56 THE CH07_FACT ERD**This Entity-Relationship Diagram (ERD) represents the structure of the *Ch07_FACT* database, which is used in managing a library of e-books.### Entities and Relationships:1. **CHECKOUT** - **Primary Key (PK):** Check_Num - **Foreign Keys (FK):** - FK1: Book_Num - FK2: Pat_ID - **Attributes:** - Check_Out_Date - Check_Due_Date - Check_In_Date Represents the checkout transaction details for e-books.2. **PATRON** - **Primary Key (PK):** Pat_ID - **Attributes:** - Pat_FName - Pat_LName - Pat_Type Contains details about the patrons (users) of the e-library.3. **BOOK** - **Primary Key (PK):** Book_Num - **Foreign Key (FK1):** Pat_ID - **Attributes:** - Book_Title - Book_Year - Book_Cost - Book_Subject Describes the properties of e-books available in the library.4. **AUTHOR** - **Primary Key (PK):** Au_ID - **Attributes:** - Au_FName - Au_LName - Au_BirthYear Contains information about the authors of the e-books.5. **WRITES** - **Primary Key (PK, FK1, FK2):** The combination of Book_Num and Au_ID - **Foreign Keys:** - FK1: Book_Num - FK2: Au_ID Establishes the relationship between books and their authors.### Relationships:- A *PATRON* can check out multiple books as recorded in the *CHECKOUT* entity.- A *BOOK* can be checked out by patrons and is authored by one or more *AUTHORS*.- The *WRITES* relationship maps books to authors, allowing a many-to-many relationship.**Context:**The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection **Problem 81**Write a query to display the highest book cost in the system (Figure P7.81).---**Figure 7.81**The figure displays a simple table with a column labeled "Most Expensive." Under this label, one entry is shown: the value "129.95," which represents the highest book cost in the system.---**Task**

Consider the following query to display the most expensive book in the FACT system: Query: select…

Answered: Problem 81 Write a query to display the…

Problem 81 Write a query to display the highest book cost in the system (Figure P7.81). Most Expensive 12995 Figure 7.81

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 list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: What is the result of the query below: SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: 7- Write a query to produce the number of invoices and the total purchase amounts by customer, using…

A: Hey, since multiple questions posted, we will answer first question according to our policy. If you…

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts, Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: Add a Calculated Field to a Totals Query In the first blank column, add a new column named Time on…

A: MS Access:- MS Access is an information and data management tool that is used to manage database and…

Q: A) Write a query which shows the employee IDs that are unique to the employee table. Order the…

A: Solution A) - In the first part, we need to write a query to employee Ids and the employee should…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: In a corporate setting, managing employee information, salary details, and departmental affiliations…

Q: n sql, an associate array is a table that is associated with a / an

A: Associate array in SQL An associative array, also known as an index-by table, is said to be a set…

Q: What are the advantages of using table-valued parameters in SQL functions

A: Table-valued parameters (TVPs) in SQL are a powerful feature that allows developers to send multiple…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: We must take into account the compensation history kept in the figure 48 table in order to get the…

Q: Write an SQL query that will show all order numbers in the Orders tablebetween 1002 and 1008

A: SQL query: Query to show all order numbers in the “Orders” table between 1002 and 1008 SELECT * FROM…

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 an SQL query using the ALTER TABLE and ADD operator to add anattribute named ORDERDATE with…

A: ALTER TABLE command: The ALTER TABLE command is used to add new columns, modify columns in an…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG ( ALL | DISTINCT ] expression )…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

**Database Schema**

The schema for the *Ch07_FACT* database is shown below and should be used to answer the next several problems.

**FIGURE P7.56 THE CH07_FACT ERD**

This Entity-Relationship Diagram (ERD) represents the structure of the *Ch07_FACT* database, which is used in managing a library of e-books.

### Entities and Relationships:

1. **CHECKOUT**
- **Primary Key (PK):** Check_Num
- **Foreign Keys (FK):**
- FK1: Book_Num
- FK2: Pat_ID
- **Attributes:**
- Check_Out_Date
- Check_Due_Date
- Check_In_Date

Represents the checkout transaction details for e-books.

2. **PATRON**
- **Primary Key (PK):** Pat_ID
- **Attributes:**
- Pat_FName
- Pat_LName
- Pat_Type

Contains details about the patrons (users) of the e-library.

3. **BOOK**
- **Primary Key (PK):** Book_Num
- **Foreign Key (FK1):** Pat_ID
- **Attributes:**
- Book_Title
- Book_Year
- Book_Cost
- Book_Subject

Describes the properties of e-books available in the library.

4. **AUTHOR**
- **Primary Key (PK):** Au_ID
- **Attributes:**
- Au_FName
- Au_LName
- Au_BirthYear

Contains information about the authors of the e-books.

5. **WRITES**
- **Primary Key (PK, FK1, FK2):** The combination of Book_Num and Au_ID
- **Foreign Keys:**
- FK1: Book_Num
- FK2: Au_ID

Establishes the relationship between books and their authors.

### Relationships:
- A *PATRON* can check out multiple books as recorded in the *CHECKOUT* entity.
- A *BOOK* can be checked out by patrons and is authored by one or more *AUTHORS*.
- The *WRITES* relationship maps books to authors, allowing a many-to-many relationship.

**Context:**

The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection

**Problem 81**

Write a query to display the highest book cost in the system (Figure P7.81).

---

**Figure 7.81**

The figure displays a simple table with a column labeled "Most Expensive." Under this label, one entry is shown: the value "129.95," which represents the highest book cost in the system.

---

**Task**

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`` 0

VIEW

Step 2

VIEW

Trending now

This is a popular 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

1. Write a query that displays the first and last name of every patron, sorted by last name and then first name. Ensure the sort is case insensitive (50 rows) PAT_FNAME Vera Holly Cedric Cory Nadine Erika Gerald Ollie robert Keith PAT_LNAME Alvarado Anthony Baldwin Barry Blair Bowen Burke Cantrell carter Cooley
SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…
Problem 9 Write a query to count the number of invoices.
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 the T-SQL scripts for the following tasks: Write a query to list the first name and last name of the employee with the highest salary in the financedepartment
a. Write a query to get all unique first names that start with the letter W from the student table. Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an T from the student table and sort them in descending order.
Write an appropriate SQL query to display all the STUDENT_SURNAMES and STUDENT_NAMES, as well as the MODULE_NAMES that the student is registered for. Sort results according to student surname in ascending order.
Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER
sc 2. The First Orders A company maintains information about its orders in the ORDERS table. Write a query to print details of the earliest five orders (sorted by ORDER_DATE, ascending) that have not been delivered (i.e., STATUS is not DELIVERED). If there are more than five orders to choose from, select the ones with the lowest order ID. Sort the output in the increasing order of order ID. The output should contain ID, ORDER_DATE, STATUS, CUSTOMER_ID. Schema Table: Orders column type int column name id order_date status customer_id Sample Data Tables X fl f2 f3 KE date varchar(50) int f4 f5 f6 团 f7 ASUS VivoBook f80/