Having the statement “the bitmap index of gender ‘male’ is 11000011000011000010 and the bitmap index of...
Having the statement “the bitmap index of gender ‘male’ is 11000011000011000010 and the bitmap index of emplymentStatus ‘fullTime’ is 10001011101001001011”. How many tuples are in this table? What is the bitmap index of female fullTime employees?
Homework Answers
In Bitmap Indexing, every bit represents the unique value of a
particular column in a tuple. Therefore, the length of the bitmap
index of every variable will be the same, and will be equal to the
number of tuples in the table.
Therefore, the number of tuples in the above table -
20
Now, it is clear that the 'gender' attribute has only 2 values - 'male' and 'female'. Therefore, It is evident that the tuples which have 0 as their index for gender 'male' will have 1 as the index for gender 'female'. So, to calculate the bitmap index of gender 'female', we can take the complement of the bitmap index of the gender 'male'.
Bitmap Index of Gender 'Female' = ~(11000011000011000010)
= 00111100111100111101
------------------------------------------------------------------------------------------------------------------------------
Now, for calculating the index of a combined attribute, we will find the bitmap values of both the attributes, and then perform logical AND operation on them.
Bitmap Index of employmentStatus 'fulltime' = 10001011101001001011
Bitmap index of 'female fulltime' = Bitmap('female') AND
Bitmap('fulltime')
= (00111100111100111101) AND (10001011101001001011)
= 00001000101000001001
Add Answer to:
Having the statement “the bitmap index of gender ‘male’ is
11000011000011000010 and the bitmap index of...
Handedness Gender Right Male Right Female Right Male Right Female Right Male Right Female Right Male...
Handedness Gender Right Male Right Female Right Male Right Female Right Male Right Female Right Male Right Female Right Male Right Male Right Male Left Female Right Female Left Male Left Male Right Female Right Female Right Female Left Male Left Male Right Male Right Male Left Male Right Male Right Female Handedness Right Right Left Right Right Right Right Right Left Left Right Right Right Right Right Right Right Left Right Right Right Right Right Right Left Gender Female...
gender income Male 48932 Male 48281 Male 49885 Male 48646 Male 49391 Male 48824 Male 49459...
gender
income
Male
48932
Male
48281
Male
49885
Male
48646
Male
49391
Male
48824
Male
49459
Male
48685
Male
48215
Male
49362
Male
47647
Male
48860
Male
47438
Male
47052
Male
48157
Male
48349
Male
49589
Male
48579
Male
48411
Male
49048
Male
48705
Male
49932
Male
48779
Male
47685
Male
48984
Male
48616
Male
47362
Male
46919
Male
47676
Male
47932
Male
48494
Male
49161
Male
48201
Male
48089
Male
48287
Male
48028
Male
48240
Male
48312
Male
47827...
SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male...
SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male 4500 Canada 3 Pam Female 5500 USA 4 Sara Female 4000 Canada 5 Todd Male 3500 Canada 6 Mary Female 5000 UK 7 Ben Male 6500 UK 8 Elizabeth Female 7000 USA 9 Tom Male 5500 UK 10 Ron Male 5000 USA Given the EMPLOYEE table above, write a query that would produce the output below. COUNTRY GENDER Total Salary ---------- ---------- ------------ Canada Female 4000 Canada Male 8000 UK Female 5000...
SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male...
SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male 4500 Canada 3 Pam Female 5500 USA 4 Sara Female 4000 Canada 5 Todd Male 3500 Canada 6 Mary Female 5000 UK 7 Ben Male 6500 UK 8 Elizabeth Female 7000 USA 9 Tom Male 5500 UK 10 Ron Male 5000 USA Given the EMPLOYEE table above, write a query that would produce the output below. COUNTRY GENDER Total Salary ---------- ---------- ------------ Canada Female 4000 Canada Male 8000 Canada NULL 12000...
The parliament of a small state has changed from having a male majority to a female one. The new ...
The parliament of a small state has changed from having a male majority to a female one. The new parliament has changed a number of policies that once clearly benefited men more, to now benefiting women more. What concept would this development be directly related to? gender compensation gender pluralism gender essentialism gender as an ascribed category
Problem # 5 (12 points) A random sample of 130 musicians was selected. Each musician was categorized by gender and...
Problem # 5 (12 points) A random sample of 130 musicians was selected. Each musician was categorized by gender and according to how they learned to play their instruments. Each musician was asked to select only one gender category (male or female) and only one, most relevant, learning mode (self-taught, studied in school or private instruction).The data is presented in the table below. Total Self-taught Private Instruction Studied in School 72 22 38 12 Female 58 15 24 19 Male...
An individual can be classified by gender as male, female, by hair color as black, blonde,...
An individual can be classified by gender as male, female, by hair color as black, blonde, brown, red, unknown, and by eye color as black, brown, green, hazel, unknown. a) How many different classifications are possible (for example, male, with blonde hair, and green eyes)? There are different classifications. b) Construct a tree diagram to determine the sample space. The tree for gender has branches. From each branch of the tree for gender, the tree for hair color has branches...
Gender HeartRate male 70 male 71 male 74 male 80 male 73 male 75 male 82...
Gender HeartRate
male 70
male 71
male 74
male 80
male 73
male 75
male 82
male 64
male 69
male 70
male 68
male 72
male 78
male 70
male 75
male 74
male 69
male 73
male 77
male 58
male 73
male 65
male 74
male 76
male 72
male 78
male 71
male 74
male 67
male 64
male 78
male 73
male 67
male 66
male 64
male 71
male 72
male 86
male 72...
DQuestion 13 Criminal Justice Major College A College B Gender of Student Male Female 879 473...
DQuestion 13 Criminal Justice Major College A College B Gender of Student Male Female 879 473 1352 65 35 100 119 64 183 65 35 Total 100 Referring to the crosstabulation table above, how rows of raw data ("cases") were required to produce this table? O 1,352 998 1.535 O can't determine Previous Quiz saved at 8:20pm D Question 14 Criminal Justice Major Gender of Student Colege A College College B Male Female 879 473 1352 65 35 100 119...
Gender Gender Preference Female Male Total Coke 85 135 220 Pepsi 120 80 200 Neither/Unsure 65...
Gender Gender Preference Female Male Total Coke 85 135 220 Pepsi 120 80 200 Neither/Unsure 65 15 80 Total 270 230 500 If an American is selected at random, what is the probability that the individual is male or prefers Pepsi? 0.43 0.16 0.70 0.35 If a male respondent is asked which soda he prefers, what is the probability that he will say Coke? 0.84 0.16 0.58 0.35
Handedness Gender Right Male Right Female Right Male Right Female Right Male Right Female Right Male Right Female Right Male Right Male Right Male Left Female Right Female Left Male Left Male Right Female Right Female Right Female Left Male Left Male Right Male Right Male Left Male Right Male Right Female Handedness Right Right Left Right Right Right Right Right Left Left Right Right Right Right Right Right Right Left Right Right Right Right Right Right Left Gender Female...
gender
income
Male
48932
Male
48281
Male
49885
Male
48646
Male
49391
Male
48824
Male
49459
Male
48685
Male
48215
Male
49362
Male
47647
Male
48860
Male
47438
Male
47052
Male
48157
Male
48349
Male
49589
Male
48579
Male
48411
Male
49048
Male
48705
Male
49932
Male
48779
Male
47685
Male
48984
Male
48616
Male
47362
Male
46919
Male
47676
Male
47932
Male
48494
Male
49161
Male
48201
Male
48089
Male
48287
Male
48028
Male
48240
Male
48312
Male
47827...
Problem # 5 (12 points) A random sample of 130 musicians was selected. Each musician was categorized by gender and according to how they learned to play their instruments. Each musician was asked to select only one gender category (male or female) and only one, most relevant, learning mode (self-taught, studied in school or private instruction).The data is presented in the table below. Total Self-taught Private Instruction Studied in School 72 22 38 12 Female 58 15 24 19 Male...
An individual can be classified by gender as male, female, by hair color as black, blonde, brown, red, unknown, and by eye color as black, brown, green, hazel, unknown. a) How many different classifications are possible (for example, male, with blonde hair, and green eyes)? There are different classifications. b) Construct a tree diagram to determine the sample space. The tree for gender has branches. From each branch of the tree for gender, the tree for hair color has branches...
Gender HeartRate
male 70
male 71
male 74
male 80
male 73
male 75
male 82
male 64
male 69
male 70
male 68
male 72
male 78
male 70
male 75
male 74
male 69
male 73
male 77
male 58
male 73
male 65
male 74
male 76
male 72
male 78
male 71
male 74
male 67
male 64
male 78
male 73
male 67
male 66
male 64
male 71
male 72
male 86
male 72...
DQuestion 13 Criminal Justice Major College A College B Gender of Student Male Female 879 473 1352 65 35 100 119 64 183 65 35 Total 100 Referring to the crosstabulation table above, how rows of raw data ("cases") were required to produce this table? O 1,352 998 1.535 O can't determine Previous Quiz saved at 8:20pm D Question 14 Criminal Justice Major Gender of Student Colege A College College B Male Female 879 473 1352 65 35 100 119...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago