CS614 Data Warehousing Assignment No 4 Discussion Spring 2014 Due Date 22 July 2014

[vuassignments]

CS614 - Data Warehousing Assignment No. 4(Graded) Solution and Discussion Spring 2014 Due Date: Jul 22, 2014


Student_Subjects

You should consult recommended books to clarify your concepts as handouts are not sufficient.
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
You are advised to upload your assignment at least two days before Due date.
This assignment file comprises of Two (2) pages.




  Untitled.jpg (Size: 28.05 KB / Downloads: 376)



Question:

Use bitmap index to execute the following queries:
Select * from Student_Subjects where SubjectCode=”CS614” and ExamCenter=”PVC001”
Select * from Student_Subjects where SubjectCode=”CS001” and ExamCenter=”PVC001”
Note: You need to specify each and every step including index tables, bit vectors etc.