**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

Similar questions

pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp_Infor Table EmpID EmpFname EmpLname Department Salary Gender Address DOB Kuantan 01/12/1977 M 1 Mohd Ali HR 2000 3500 Ipoh 02/05/1975 F 5000 Kuala Lumpur 01/01/1984 M 1800 Georgetown 02/05/1995 Kangar 03/07/1998 8000 2 3 4 5 Azizah Chen Ananthi Manjit Suliman Kang Kulkarni Sidhu Admin Account HR Admin 1. Write the query to display all the records in the Emp_Infor table. FM 2. Write a query to display the number of employees working in the department 'HR'. 3. Write a query to display the EmpFname from the EMP_Infor table and use the ALIAS name as Staff Name..
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
How do we avoid getting duplicate entries in a query?
The DEPARTMENTS table has the following data: DEPARTMENT ID DEPARTMENT NAME MANAGER ID LOCATION_ID 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 What will be the value in the first row of the result set when the following query is executed? SELECT manager_id FROM departments ORDER BY location_id; O a. 201 O b. 149 O c. 103 O d. 200
Write query of it.
SOQL Assignment: You are required to construct a SOQL Query in which we must locate all of the contacts whose accountld is not null and order the first names in descending order in order to complete the assignment.
Write a SQL query to add constraint PRIMARY KEY to the column Doc_ID with a suitable constraint name Mart 250
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 advantage and disadvantage of a query
What is the difference between an EXCEPT (MINUS) query and a UNION query?