Question # 1:

Create inverted index by considering the following documents and their text.

 

Doc1: How many students are enrolled in session 2017-2018?

Doc2: How many courses are offered in first semester?

Doc3: How many students have not paid their fee?

 

 

Question # 2:

 

Consider the following bitmap indexes created for three columns:

 

Bitmap index created on column Designation:

 

Emp id

Lecturer

Assistant Professor

Associate Professor

Professor

E01

1

0

0

0

E02

0

0

1

0

E03

0

0

1

0

E04

0

0

0

1

E05

1

0

0

0

E06

0

1

0

0

E07

0

1

0

0

 

Bitmap index created on column Department:

 

Emp id

Biology

Mathematics

Computer Science

E01

1

0

0

E02

1

0

0

E03

0

1

0

E04

0

0

1

E05

1

0

0

E06

0

1

0

E07

0

0

1

 

Bitmap index created on column Specialization:

 

Emp id

Software Engineering

Database

Artificial Intelligence

E01

1

0

0

E02

0

1

0

E03

0

0

1

E04

0

0

1

E05

1

0

0

E06

0

1

0

E07

1

0

0

 

 

Solve the following queries using above given bitmap indexes. Mention all steps.

 

Query1: How many employee belong to “Computer Science” Department.

 

Query2: Get Employees having Designation “Assistant Professor” and Specialization “Software Engineering”.

 

Query3: Get Employees having Designation “Lecturer” and Department “Mathematics” or “Biology”.

Note: Deadline for assignment submission is 23rd July 2018.

Views: 549

Replies to This Discussion

بھائیوں اور بہنوں یہ آسائنمٹ نہایت آسان ہے ہینڈ آؤٹ میں انورٹڈ انڈیکس اور بیٹمیپ انڈیکس کی مثالیں دیکھ لیں

Bhai kis lecture se hai ye examples ??

Image may contain: text

Readable ni hi kia krin. please clear copy pest krin

Ya koi reference bata din

it's from lesson 26 & 27

RSS

Discussion Forum

CS614 Assignment # 2 Due Date 22 May, 2018

Started by ★·.·★ Ќąɲώąℓ ★·.·★.
Last reply
by + caмe4ѕтυdιeѕ May 23. 5 Replies

CS614 Assign # 1 Due Date: 9th May, 2018

Started by + caмe4ѕтυdιeѕ.
Last reply
by Meerub Fatima May 9. 2 Replies

CS614 Finalterm Papers from 17 to 28 Feb, 2018

Started by + caмe4ѕтυdιeѕ.
Last reply
by + caмe4ѕтυdιeѕ Feb 22. 2 Replies

SPONSORED LINKS

© 2018   Created by Muhammad Anwar Tahseen.   Powered by

Badges  |  Report an Issue  |  Terms of Service