Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 7, Problem 26P
Find the total value of the product inventory. The results are shown in Figure P7.26.
FIGURE P7.26 TOTAL VALUE OF ALL PRODUCTS IN INVENTORY
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Calculate the "Days on Market" in column L by finding the difference between Date Sold icokumn
and Date Listed (column H) first. What is the average Sales Price for all the properties with 2or
more bedrooms and more than 180 days on the market?
Below are some rows of the PROVIDERS table for a factory:
Â
PCODE
NAME
PHONE
10192
Hans, Inc.
231 - 3092
98411
Tools and More
231 - 1029
0489035
Motors Inc.
993 - 1821
Â
All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate?
Â
Â
a.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’
Â
b.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’
Â
c.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’
Â
d.
SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’
Q4
There are 9 workers for ASH Development Sdn. Bhd.
Unfortunately, there are only 4 rooms available for these workers. Every
week, a worker name is randomly selected to do odd jobs for the company.
When a worker has been selected randomly, a
these rooms are full. Based on Figure Q4, worker's ID number 0 (Umar) is
randomly selected for the first week, and the 4 boxes represent 4 rooms for
as shown in Table Q4.
room needs to be vacated if
workers.
Table Q4
Worker's ID
Worker's Name
Umar
1.
Lukman
Arif
Yusuf
Anas
Muadz
Aleef
Hafiz
8.
Amir
9.
Taufik
WI
4
6
2
9.
4
1
3
8
D
R2
R3
R4
W
W
W1
w1
Wi
w1
W1
w1
w1
wi
Wi
W1
2
3
4 56
78 9
1
2
3
4
5
6
8
9
Figure Q4
Investigate the number of page faults occur by illustrating the way how the room is managed
using the list of weekly random selection of workers as shown in Figure Q4 using the
following algorithms:
(a)
Optimal Page Replacement (OPR) replacement algorithm
2.
RRR
Chapter 7 Solutions
Database Systems: Design, Implementation, & Management
Ch. 7 - Prob. 1RQCh. 7 - Explain why the following command would create an...Ch. 7 - What is a cross join? Give an example of its...Ch. 7 - What three join types are included in the outer...Ch. 7 - Using tables named T1 and T2, write a query...Ch. 7 - Prob. 6RQCh. 7 - Rewrite the following WHERE clause without the use...Ch. 7 - Explain the difference between an ORDER BY clause...Ch. 7 - Explain why the following two commands produce...Ch. 7 - What is the difference between the COUNT aggregate...
Ch. 7 - Prob. 11RQCh. 7 - Prob. 12RQCh. 7 - Prob. 13RQCh. 7 - Prob. 14RQCh. 7 - Prob. 15RQCh. 7 - What does it mean to say that SQL operators are...Ch. 7 - Prob. 17RQCh. 7 - Prob. 18RQCh. 7 - Prob. 19RQCh. 7 - Prob. 20RQCh. 7 - Given the employee information in Question 19,...Ch. 7 - Given the employee information in Question 19,...Ch. 7 - Prob. 23RQCh. 7 - Prob. 24RQCh. 7 - Prob. 25RQCh. 7 - What Oracle function should you use to calculate...Ch. 7 - What string function should you use to list the...Ch. 7 - Prob. 28RQCh. 7 - Given the structure and contents of the...Ch. 7 - Using the EMPLOYEE, JOB, and PROJECT tables in the...Ch. 7 - Write the SQL code that will produce the same...Ch. 7 - Prob. 4PCh. 7 - Write the SQL code to validate the ASSIGN_CHARGE...Ch. 7 - Using the data in the ASSIGNMENT table, write the...Ch. 7 - Prob. 7PCh. 7 - Prob. 8PCh. 7 - Prob. 9PCh. 7 - Prob. 10PCh. 7 - Generate a listing of all purchases made by the...Ch. 7 - Prob. 12PCh. 7 - Prob. 13PCh. 7 - Modify the query in Problem 13 to include the...Ch. 7 - Prob. 15PCh. 7 - Prob. 16PCh. 7 - Prob. 17PCh. 7 - Prob. 18PCh. 7 - Prob. 19PCh. 7 - Prob. 20PCh. 7 - Prob. 21PCh. 7 - Create a query to find the balance characteristics...Ch. 7 - Prob. 23PCh. 7 - Prob. 24PCh. 7 - Prob. 25PCh. 7 - Find the total value of the product inventory. The...Ch. 7 - Prob. 27PCh. 7 - Write a query to display the SKU (stock keeping...Ch. 7 - Prob. 29PCh. 7 - Prob. 30PCh. 7 - Prob. 31PCh. 7 - Prob. 32PCh. 7 - Prob. 33PCh. 7 - Prob. 34PCh. 7 - Prob. 35PCh. 7 - Prob. 36PCh. 7 - Prob. 37PCh. 7 - Prob. 38PCh. 7 - Prob. 39PCh. 7 - Prob. 40PCh. 7 - Prob. 41PCh. 7 - Prob. 42PCh. 7 - Prob. 43PCh. 7 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Prob. 47PCh. 7 - Prob. 48PCh. 7 - Prob. 49PCh. 7 - Prob. 50PCh. 7 - Prob. 51PCh. 7 - Prob. 52PCh. 7 - Prob. 53PCh. 7 - Prob. 54PCh. 7 - Prob. 55PCh. 7 - Prob. 56PCh. 7 - Prob. 57PCh. 7 - Prob. 58PCh. 7 - Prob. 59PCh. 7 - Prob. 60PCh. 7 - Prob. 61PCh. 7 - Prob. 62PCh. 7 - Prob. 63PCh. 7 - Prob. 64PCh. 7 - Prob. 65PCh. 7 - Prob. 66PCh. 7 - Prob. 67PCh. 7 - Prob. 68PCh. 7 - Prob. 69PCh. 7 - Prob. 70PCh. 7 - Prob. 71PCh. 7 - Prob. 72PCh. 7 - Prob. 73PCh. 7 - Prob. 74PCh. 7 - Prob. 75PCh. 7 - Prob. 76PCh. 7 - Prob. 77PCh. 7 - Prob. 78PCh. 7 - Prob. 79PCh. 7 - Prob. 80PCh. 7 - Prob. 81PCh. 7 - Prob. 82PCh. 7 - Prob. 83PCh. 7 - Prob. 84PCh. 7 - Prob. 85PCh. 7 - Prob. 86PCh. 7 - Prob. 88PCh. 7 - Prob. 89PCh. 7 - Prob. 90PCh. 7 - Prob. 91PCh. 7 - Prob. 92PCh. 7 - Prob. 93PCh. 7 - Prob. 94PCh. 7 - Prob. 95PCh. 7 - Prob. 96PCh. 7 - Prob. 97PCh. 7 - Prob. 98PCh. 7 - Prob. 99PCh. 7 - Prob. 100PCh. 7 - Prob. 101PCh. 7 - Prob. 102PCh. 7 - Prob. 103PCh. 7 - Prob. 104PCh. 7 - Prob. 105PCh. 7 - Prob. 106PCh. 7 - Prob. 107PCh. 7 - Prob. 108PCh. 7 - Prob. 109P
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
- Find the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price_per_unit Products table: product_id (Primary key) product_namearrow_forward1. For each sale made on June 1, 2015, show the following information:  CustomerID, Customer name (lastname + comma + space +  firstname) as 'CustomerName', SaleDate, Sum of Tax and Shipping as 'tax_shipping'. Sort it by customer last name. 2. For each sale made on June 1, 2015, show the following information:  CustomerID, Customer name (lastname + comma + space +  firstname) as 'CustomerName', SaleDate, ProductName, ItemSize, Quantity and the total amount of each sale item (quantity times SalePrice as 'SaleAmount'). Sort it by customer last name. Hint: The answer result will have a record for each SaleItem. 3. The color field in the Product table has a mix of single colors or multiple colors separated by commas. Provide a list of Products and replace every comma with a semicolon plus one space.  Name the column 'OpenColor'.  Show ProductID, ProductName, Composition, Category, and 'OpenColor'.  For simplicity include only ProductIDs for products with a list price of less than $20 and…arrow_forwardThe table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 0GD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.arrow_forward
- In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.arrow_forwardAdd the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM 2011 2100 D552 Sarah Qasim B.Med 2013 1500 D553 Zuhair Mohammad DOM 2008 1600 D554 Amera Jalal MBBS 2006 1000 4. Show the doctor's names, degree and salary for all doctors who join between 2010 and 2015arrow_forwardFind your group number• The remainder after division of second to last digit of your student id by 3 is a.• The last digit of your student id is b.• Your group number is ab, which is an integer between 0 and 29.• If your group number is equal to ab=00 then take it as ab=01.Examples:• Student Id = 290316027 → Group = 27• Student Id = 290315043 → Group = 13• Student Id = 280315061 → Group = 01• Student Id = 270316085 → Group = 25• Student Id = 290315027 → Group = 27  my student Id is 280316014 but i didnt calculate ab.Can you help me .Thank you.arrow_forward
- Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM 2011 2100 D552 Sarah Qasim B.Med 2013 1500 D553 Zuhair Mohammad DOM 2008 1600 D554 Amera Jalal MBBS 2006 1000 3. Show all Doctors details who join after 2005 and their salary is less than 1,500arrow_forwardFind the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price per unit Products table: product_id (Primary key) product_namearrow_forwardSome rows of the STUDENT table are shown below: Â CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Â Which best describes the result of the query below? Â SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR Â Â a. The average maximum GPA of all the students in each year. Â b. The year of the student with the maximum GPA. Â c. The average GPA of students with a GPA higher than 2.0 each year. Â d. The average GPA of the students with a GPA higher than 2.0.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License