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 3P
Textbook Problem
195 views

Using Table 11.4 as an example, create two alternative access plans. Use the following assumptions:

  1. a. There are 8,000 employees.
  2. b. There are 4,150 female employees.
  3. c. There are 370 employees in area code 615.
  4. d. There are 190 female employees in area code 615.

Explanation of Solution

Creating two alternative access plans with the data that are provided:

The below table shows the two alternative access plans for the data that are provided:

Given:

Total Employee: 8000

Number of female Employee: 4500

Number of employee in the area code 615: 370

Number of female employees in the area code 615:190

Assumption:

Considering there are no indexes and reading each row will have I/O cost of “1”.

Table creation:

Plan Step Operations I/O operations I/O cost Resulting row sets Total I/O cost
A A1

Performs a full table scan in table “EMPLOYEE”

Selects rows with EMP_SEX=’F’ and EMP_AREACODE=’615’

8,000 8,000 190 8,000
A2 Perform SORT operations and select rows that match the given criteria (First Name and Last Name). 190 190 190 8,190
B B1

Performs Index scan for the given area code. (MY_NDX1).

Select rows based on the area code.

370 370 370 370
B2 Performs table access based on ROWID in the table EMPLOYEE 370 370 370 740
B3

Selects rows that match the given criteria...

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 are some basic database functions that a spreadsheet cannot perform?

Database Systems: Design, Implementation, & Management

What is the difference between a threat agent and a threat?

Principles of Information Security (MindTap Course List)

List five common sources for transmission fluid leaks.

Automotive Technology: A Systems Approach (MindTap Course List)

In Chapter 13, we explained that when a spring is stretched or compressed from its unstretched position, elasti...

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

What is the difference between a CSO and a CISO?

Management Of Information Security

Convert 10,000 ft-lbf of energy into BTU, Joules, and kilojoules.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

_____ refers to the number of bytes a storage medium can hold. Identify terms manufacturers use to determine th...

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)

What causes most firewall failures?

Network+ Guide to Networks (MindTap Course List)