We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

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.


+ Click Here To Join also Our facebook study Group.


..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 4810

.

+ http://bit.ly/vucodes (Vu Study Groups By Subject Codes Wise)

Attachments:

Replies to This Discussion

here is the solution guys according to my point of view.. if u find any mistakes also inform me....also dont copy this as it is folllow ur pattern for the assignment .. thx

Attachments:

1st question ki smj ni aai yh kesy kiya ha

main ny b asa e solvekia tha q1 kia ya he method h q1 ko solve karny ka??

Brother u made mistake you picked Associate professor data instead of assistant professor

Ist Question bi galt hai .

Bhai AND operation kis k sath krna h & OR operation kis k sath??? Iski mjhe smjh ni ai

statement ko orderwise index kerna hai ?

order sequence handouts main different hai page no. 232

1st answer i think theek ha according to this example:

2nd question ma data galat ha like kaleem ullah khan pointed out.

Last ma I think Answer 1, Answer 2 ka OR operation karna ha.. like this.

000000
100010
---------
100010

I think or means we have to select either math or bio as AND operation...

1 st question is right according to chapter 26,27 in handouts, i also prepared like same one,, whts about 2nd question

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service