.... How to Find Your Subject Study Group & Join ....   .... Find Your Subject Study Group & Join ....  

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

Study Groups By Subject code Wise (Click Below on your university link & Join Your Subject Group)

[ + VU Study Groups Subject Code Wise ]  [ + COMSATS Virtual Campus Study Groups Subject Code Wise ]

Looking For Something at vustudents.ning.com? Search 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.

Share This With Friends......


How to Find Your Subject Study Group & Join.

Find Your Subject Study Group & Join.

+ Click Here To Join also Our facebook study Group.


This Content Originally Published by a member of VU Students.

+ Prohibited Content On Site + Report a violation + Report an Issue

+ Safety Guidelines for New + Site FAQ & Rules + Safety Matters

+ Important for All Members Take a Look + Online Safety


Views: 4738

See Your Saved Posts Timeline

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

Donation

A quality education changes lives & start with you.

Latest Activity

Profile IconM.Asif, Muhammad Arslan, khadija bukhari and 21 more joined Virtual University of Pakistan
9 minutes ago
Ghulam Dastagir replied to Honey's discussion CS201 in the group CS201 Introduction to Programming
15 minutes ago
Profile IconGhulam Dastagir, zisani and Hamza Arshad joined + M.TariK MaliC's group
15 minutes ago
altaf hussain posted a status
"please provide me complete complete solved gdb. mgt201"
16 minutes ago
+(✿◠‿◠)ŞƥąŗƘℓe Ƒąiŗɣ(✿◠‿◠)+ and Malik Irfan are now friends
27 minutes ago
Ghulam Dastagir posted discussions
30 minutes ago
jawad ahmad replied to + AW (BSCS 7)'s discussion MGT201 - Financial Management GDB NO.1 due date November 22, 2018 in the group MGT201 Financial Management
35 minutes ago
Zarq Zafar liked + M.TariK MaliC's group MGT601 SME Management
39 minutes ago

Forum Categorizes

Job's & Careers (Latest Jobs)

Admissions (Latest Admissons)

Scholarship (Latest Scholarships)

Internship (Latest Internships)

VU Subject Study Groups

Other Universities/Colleges/Schools Help

    ::::::::::: More Categorizes :::::::::::

Member of The Month

1. Ahmad

Lahore, Pakistan

© 2018   Created by + M.TariK MaliC.   Powered by

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