# Using Table 11.4 as an example, create two alternative access plans. Use the following assumptions: a. There are 8,000 employees. b. There are 4,150 female employees. c. There are 370 employees in area code 615. d. There are 190 female employees in area code 615.

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

## Using Table 11.4 as an example, create two alternative access plans. Use the following assumptions: a. There are 8,000 employees. b. There are 4,150 female employees. c. There are 370 employees in area code 615. 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

Find more solutions based on key concepts
List and describe the different types of databases.

Database Systems: Design, Implementation, & Management

What is steganography, and what can it be used for?

Principles of Information Security (MindTap Course List)

Principles of Information Systems (MindTap Course List)

Calculate the efficacy for the following lights: (a) Sylvania accent LED light, which uses 2 watts and produces...

Engineering Fundamentals: An Introduction to Engineering (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)

Why might you connect to a wireless network on your smartphone instead of using your mobile data plan?

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

Which electrodes would be grouped in the following F numbers: B, F2, F4?

Welding: Principles and Applications (MindTap Course List)