menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

Problems 29–32 are based on the following query: SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE) FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINE WHERE CUS_AREACODE = '615' GROUP BY CUS_CODE; Assuming that you generate 15,000 invoices per month, what recommendation would you give the designer about the use of derived attributes?

BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 11, Problem 29P
Textbook Problem
5 views

Problems 29–32 are based on the following query:

SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)
FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINE
WHERE CUS_AREACODE = '615'
GROUP BY CUS_CODE;

Assuming that you generate 15,000 invoices per month, what recommendation would you give the designer about the use of derived attributes?

Program Plan Intro

Usage of derived attributes:

  • The derived attributes are used to minimize the computations that are established in the execution of queries and join operations.
  • Derived attributes are highly used during the execution of the aggregate queries.

Explanation of Solution

Recommendation that is given to the designer in the usage of derived attributes:

The below are the recommendations that are given to the designer for the usage of derived attributes:

  • The given query utilizes the aggregate function “MAX” in order to compute the customer’s maximum invoice line number.
  • The given table gets increased at the rows rate of 15,000 per month and because of that the query can take significant amount of time in order of executing the rows that gets increases...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 11 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 11 - What are optimizer hints, and how are they used?Ch. 11 - What are some general guidelines for creating and...Ch. 11 - Most query optimization techniques are designed to...Ch. 11 - What recommendations would you make for managing...Ch. 11 - What does RAID stand for, and what are some...Ch. 11 - SELECT SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE,...Ch. 11 - Problem 1 and 2 are based on the following query:...Ch. 11 - Using Table 11.4 as an example, create two...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - SELECT SELECT P_CODE, P_DESCRIPT, P_PRICE,...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Problems 27 and 28 are based on the following...Ch. 11 - Problems 27 and 28 are based on the following...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is a relationship, and what three types of relationships exist?

Database Systems: Design, Implementation, & Management

Sir Isaac Newton discovered that any two masses m1 and m2 attract each other with a force that is equal in magn...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is a SWOT analysis? Prepare a SWOT analysis of your school or your employer.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

What is joint application design?

Management Of Information Security

Compute the nominal flexural strength of the composite beam in Problem 9.1-2. Use Fy=50 ksi.

Steel Design (Activate Learning with these NEW titles from Engineering!)

Define these terms: data, software, and command. Give example of a user response.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

How many bits does an IPv6 address contain?

Network+ Guide to Networks (MindTap Course List)

What is hot work?

Welding: Principles and Applications (MindTap Course List)