CS 614

ASSIGNMENT

CS614

Index table for Country_name

ID	Pakistan	South Africa	Australia	West Indies
PK-01	1	0	0	0
PK-05	1	0	0	0
SA-07	0	1	0	0
SA-09	0	1	0	0
AU-01	0	0	1	0
AU-04	0	0	1	0
WI-01	0	0	0	1
WI-06	0	0	0	1

Bit vector for

Pakistan= 11000000

South Africa = 00110000

Australia = 00001100

West Indies = 00000011

Index table for Player_type

Player_ID	Batsman	Bowler	Wicket Keeper	All Rounder
PK-01	1	0	0	0
PK-05	0	1	0	0
SA-07	1	0	0	0
SA-09	0	0	1	0
AU-01	0	0	0	1
AU-04	0	1	0	0
WI-01	1	0	0	0
WI-06	0	0	0	1

Bit vector for

Batsman= 10100010

Bowler= 01000100

Wicket Keeper = 00010000

All Rounder= 00001001