CS614 Data Warehousing Assignment 4 Solution Spring 2014

Consider the following table:

Student_Subjects

StudentID SubjectCode ExamCenter
124 CS614 PVC001
455 CS001 PVC002
367 CS614 PVC001
486 CS403 PVC001
524 CS101 PVC003
657 CS614 PVC002

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.

DOWNLOAD SOLUTION HERE
loading...