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: 4820

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Attachments:

Replies to This Discussion

can anyone provide these highlighted documents and text !!!

Or guide from where I can Get them....!!! Many Thanks


Doc1:

Doc2:

Doc3:

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?


ye 3 documents e hn...inhy inverted index me convert krna hai.

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?

Ok , but data kahan say laina hay iska ... i mean number of students for the session 2017-18 , courses offered in first semester and students have not paid their fee ???

ye data e hai...doc1, doc2, doc3 me jo likha hai wo data e hai

g han

Angry bird... plz share solution file

didn't completed yet. working on it. will upload soon IN SHA ALLAH

Ok..
Thank you !!!
Plz share solution...
Assignment plz cs614 solution

plz upload the solved file

RSS

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

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