Data warehousing (CS614)

Data warehousing (CS614)
Assignment # 5
Total marks = 20
Deadline Date = 01-07-2013

Please carefully read the following instructions before attempting the assignment.

Rules for Marking
It should be clear that your assignment would not get any credit if:

• The assignment is submitted after due date.
• The submitted assignment does not open or file is corrupt.
• The assignment is copied. Note that strict action would be taken if the submitted assignment is copied from any other student. Both students will be punished severely.

1. You should consult recommended books to clarify your concepts as handouts are not sufficient.
2. You are supposed to submit your assignment in .doc format. Any other formats like scan images, PDF, Zip, rar, bmp, docx etc will not be accepted
3. You are advised to upload your assignment at least two days before Due date.
4. This assignment file comprises of two (2) pages.

Important Note: 

Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the deadline to avoid inconvenience later on.

For any query please contact: CS614@vu.edu.pk

Reference:

Please refer to the case study given in assignment no. 1

Scenario:


After finding the duplicate records in assignment no 4, we have now deleted those records and the resultant “Tickets” table is given as under:

PFirstName	PMiddleName	PLastName	PCellno	TicketID	TicketType	FlightID
ebrahim	khan	yusafzai	92314630	052	e	pk507
arif	raza	awan	92333553	090	b	pk307
abdul	wahab	khan	92321553	012	e	pk922
muhammad	ali	raza	92334544	082	b	pk507
arshad	ali	khan	92314713	001	e	pk614

Question:

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.