Given scenario: In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges. Below 50000(B1) to below 60000(B2) to below 70000(B3) and above (B4) Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range. Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Expert Solution & Answer

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Answer 8

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Answer 9

Chapter 14, Problem 13PE

Explanation of Solution

Given scenario:

In the given case, there are 12 rows. Bitmap indexing is done on the salary ranges.

Below 50000(B1)

to below 60000(B2)

to below 70000(B3)

and above (B4)

Therefore, there will be 4 rows of each for each range. Each row has 12 columns. Bitmap will have the value 1 for a row in the relation if the salary is under that range.

Only third row (salary 40000 i.e., below 50000) in the relation satisfies the salary range of B1...

Answer 10

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Answer 11

Explanation of Solution

b. Select query is:

Select * from instructor where department=finance and salary>=80000

Therefore, two bit maps are required for this query. One should be on department and another on salary.

Bitmap on department(7 departments):

Comp. 100000100010
Finance 010000001000
Music 001000000000
Physics 000101000000
History 000010010000
Biology 000000000100
Elec. Eng...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 14 - Prob. 1PE Ch. 14 - Prob. 2PE Ch. 14 - Prob. 3PE Ch. 14 - Prob. 4PE Ch. 14 - Prob. 5PE Ch. 14 - Prob. 7PE Ch. 14 - Prob. 8PE Ch. 14 - Prob. 9PE Ch. 14 - Prob. 10PE Ch. 14 - Prob. 11PE

Concept explainers

Explanation of Solution

Explanation of Solution

Want to see the full answer?

Chapter 14 Solutions

Comp.	100000100010
Finance	010000001000
Music	001000000000
Physics	000101000000
History	000010010000
Biology	000000000100
Elec. Eng...