After finding the duplicate records in assignment no 4, we have now deleted those records and the resultant “Tickets” table is given as under:
Use the bitmap index to exploit the following queries:
1) Select * from Tickets where TicketType = “e” and FlightID=”pk507”
2) Select * from Tickets where TicketType = “b” and FlightID=”pk307”
Note: Values are present for all the columns and rows. No column has unknown value. You need to specify each and every step including index tables, bit vectors etc.
Lecture No.27 Page no.220………….. Read bitmap topic and see exampleDOWNLOAD SOLUTION HERE