.... 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: 4694

See Your Saved Posts Timeline

Attachments:

Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

Discussed & be touched with this discussion. After discussion a perfect solution will come in a result at the end.

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

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

 

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Mada Banda Fail ho jaega assignment smjh nai arahi

2nd question ke end wale sawal ka masla hai koi bata sakta hai ke dono bar and operation hi ho ga ya aik bar and aur aik bar or operation ho ga

Bhai phle

Employee having designation “Lecturer” and Department “Mathematics” ka AND lena hy. 
Phr 

Employee having designation “Lecturer” and Department “Biology ka AND lena hy.

us k bad in dono results ka OR Lena hy ap. jo k yh aye ga 

=       1000100

helo friends 
me mcs kr chuka ho mn dekha sb yha p aj parehan he cs 614 k solution k bre me to mn khud bna k send ki sb ko jo ni faida le chuke wo ye le idr paste kr raho me mre bs dua kr dena 
ye lo soluAssignment no 3 
Cs 614 
Student id : 
Q1:
Ans: the possible inverted index by considering the DOC1 DOC 2 DOC 3 and their text is as followers 
How ---------[DOC1 ,DOC2 , DOC3]
Many ------------[doc1,doc2 doc3]
Student -------------[doc1 doc3]
Are ---------------[doc1 doc 2]
Enrolled -------------[doc1]
In------------------ [doc1 doc 2]
Session ----------------[doc1]
2017 --------------------[doc1]
2018 -----------------[doc1]
Courses-----------[doc2]
Offered -----------------[doc2]
First ---------------[doc2]
Smester --------------[doc2]
Have --------------[doc3]
Not ---------------[doc3]
Paid --------------[doc3]
Their -------------[doc3]
Fee-----------------[doc3]
Q#2
Query 1: How many employee belong to “Computer Science” Department.
Ans: ther are two employee belong to “Computer Science” Department.

Query2: Get Employees having Designation “Assistant Professor” and Specialization “Software Engineering”.
Ans :
Bit map index query 
Get employ with designation = “Assistant Professor” and Specialization= “Software Engineering”.
List for designation =assistant professor 0110000

List for designation =specialization 1000101
By following and method

0110000
1000101 
------------------
Ans 0000000

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

Ans : Get Employees with Designation= “Lecturer” and Department= “Mathematics” or “Biology

Bit map index query 
Get employ with designation = “lecturer ” and department = “mathematics ”.
List for designation =lecturer 1000100

List for designation =mathematics 0010010
By following and method

1000100
0010010
------------------
Ans 0000000

Or

Get employ with designation = “lecturer ” and department = “biology ”.
List for designation =lecturer 1000100

List for designation =biology 1100100
By following and method

1000100
1100100
------------------
Ans 1000100

tion

last part wrong hai. 

Department pr OR operation use kr k thn jo ans ayega usy use krna hai, aur Desigantion k sath uska AND operation lena hai. Bio and maths k liye alag alag nhi kr sakte. kiu k question me ek bar AND hai aur dusri bar OR

Image may contain: text

it's from lesson 26 & 27

cs614-3

Attachments:

RSS

Forum Categorizes

Job's & Careers (Latest Jobs)

Admissions (Latest Admissons)

Scholarship (Latest Scholarships)

Internship (Latest Internships)

VU Study

Other Universities/Colleges/Schools Help

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

Member of The Month

1. + ! ! ! ! ϝιƴα ^

İzmir, Turkey

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

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