# 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?

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Chapter
Section

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 11, Problem 29P
Textbook Problem
125 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

#### Additional Engineering Textbook Solutions

Find more solutions based on key concepts
What is a honeypot? How is it different from a honeynet?

Principles of Information Security (MindTap Course List)

What does TPI stand for in relation to tapers?

Precision Machining Technology (MindTap Course List)

Explain why a small PCV valve opening is adequate at idle speed.

Automotive Technology: A Systems Approach (MindTap Course List)

What is equivalent future worth of the cash flow given in the accompanying figure? Assume i = 8%.

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

Describe the strategy of termination.

Management Of Information Security

Calculate the reactions at the built-in support at C, neglecting the weights of the members.

International Edition---engineering Mechanics: Statics, 4th Edition

Describe the purpose of an adapter card and the role of an expansion slot. List types of adapter cards.

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)

List two advantages to using virtualization on a network.

Network+ Guide to Networks (MindTap Course List)