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

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

Chapter
Section

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

Find more solutions based on key concepts
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)