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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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.

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 4906

.

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

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

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

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

Latest Activity

+ ! ! ! ❣ Sanam ❣ !+ is now friends with Hassan Ali, +++~~Prince of Charms~~++++, + ! ! ! ! ! ! ! Captain+ and Noman Ijaz more
19 minutes ago
Noor ijaz and M. Haris are now friends
30 minutes ago
Shanzay commented on Mani Siddiqui BS VIII's status
1 hour ago
Mani Siddiqui BS VIII posted a status
""___زندگی بڑی عجیب ہے کبھی گُلزار سی، کبھی بیزار سی"
1 hour ago
Hina liked Muhammad Shahid Javed's profile
1 hour ago
مخلص posted a discussion
2 hours ago
sabir khan posted a discussion
2 hours ago
LILY replied to LILY's discussion HAPPY INDEPENDENCE DAY
2 hours ago
LILY replied to LILY's discussion HAPPY INDEPENDENCE DAY
2 hours ago
M. Haris liked Naaz Bajwa's profile
2 hours ago
M. Haris updated their profile
3 hours ago
Bilal joined +M.Tariq Malik's group
4 hours ago
Muhammad Bilal liked zohaib iftikhar's discussion ...* KIA NAMAZ MAIN KISI KO SALAM KRNY SY NAMAZ TOOT JATI HAI?...*
10 hours ago
zohaib iftikhar replied to zohaib iftikhar's discussion ...* NA SABOOT HAI NA DALEEL HAI...*
10 hours ago
zohaib iftikhar replied to zohaib iftikhar's discussion ...* KIA NAMAZ MAIN KISI KO SALAM KRNY SY NAMAZ TOOT JATI HAI?...*
10 hours ago
zohaib iftikhar liked zohaib iftikhar's discussion ...* KIA NAMAZ MAIN KISI KO SALAM KRNY SY NAMAZ TOOT JATI HAI?...*
10 hours ago
zohaib iftikhar posted discussions
10 hours ago
Muhammad Bilal liked zohaib iftikhar's discussion ...* SUNO ...SUNO NA!...*
10 hours ago
Muhammad Bilal replied to zohaib iftikhar's discussion ...* NA SABOOT HAI NA DALEEL HAI...*
10 hours ago
Muhammad Bilal liked zohaib iftikhar's discussion ...* NA SABOOT HAI NA DALEEL HAI...*
10 hours ago

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

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

.