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

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS614 ASSIGNMENT NO 3 Spring 2019 Due Date: 01 August 2019

Question No. 1

Consider a garments factory where a Men’s casual shirts are manufactured. Each Shirt requires 15 minutes for completion. The factory management is now interested in introducing a pipeline where cutting, stitching and finalizing the shirt will be done in parallel.

You are required to calculate the Speed-up that could be achieved after implementing pipeline for manufacturing of 25 shirts in a row.

Question No. 2
Consider two database tables X and Y, we are required to join these tables using Nested-Loop Join, Assume that indexing is not used in mentioned tables.
The table information is given as:
Size of Table X = 600 blocks
Size of Table Y = 900 blocks
Qualifying blocks for Table X = 50
Qualifying blocks for Table Y = 100

Calculate the join cost for X&Y and also for Y&X; after calculations mention which Table should be the outer one X or Y.

Your assignment must be uploaded on VULMS on or before August 01, 2019. While August 02, 2019 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email.

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

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

Views: 1692

.

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

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

### Replies to This Discussion

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.

“How to Join Subject Study Groups & Get Helping Material”

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

Share below link with friends for solution & Discussion. A Single link for help in your education.

http://bit.ly/vucodes

Site Overview | Assignment Solutions | Past Papers |Site Features

CS614 Assignment No 03 Solution Spring 2019

CS614 Assignment No 03 Solution Spring 2019

+ M.Tariq Malik  Thanks for sharing

good

# CS614 Assignment 3 Solution 2019

koi plz guide sakta hy mujhe 2nd question me confusion ho rahi hy.. values to unho ne di nahi hui to khud se assume karni hain na? ya same hi likh deni hain. plz guide me

sis values  given hain 2nd question me un values ko ly kr hi question solve krna hai.

°`·Я Hk D Яаиî·´°  thanks for sharing

ALLAH bless you dear

34% kase aya

CS614 Assignment No 03 Solution Spring 2019

CS614 Assignment No 03 Solution Spring 2019

in solution no need to convert minute in to second and y will be the outer table and x will be inner table because of large number of I/Os to locate the rows

## Latest Activity

+ "AS" replied to + "AS"'s discussion Neelam Mat Karna ...
2 minutes ago
ϝ ι ყ α posted a discussion

### When You Block \$omeone.......XD XD !!

23 minutes ago
ϝ ι ყ α replied to + "AS"'s discussion Neelam Mat Karna ...
31 minutes ago
34 minutes ago
+ M.Tariq Malik left a comment for Waqas Kh@n
36 minutes ago
37 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
38 minutes ago
+ M.Tariq Malik left a comment for AsadJaved
39 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
40 minutes ago
+ M.Tariq Malik left a comment for CS619
40 minutes ago
+ M.Tariq Malik left a comment for Zahid Iqbal
41 minutes ago
+ M.Tariq Malik left a comment for Zain
42 minutes ago
+ M.Tariq Malik left a comment for Zareen
43 minutes ago
+ M.Tariq Malik left a comment for Malik AB
44 minutes ago
47 minutes ago
57 minutes ago
+++LEARNER+++ posted discussions
1 hour ago
ayesha joined + M.Tariq Malik's group

### CS614 Data Warehousing

1 hour ago
ayesha joined + M.Tariq Malik's group

1 hour ago
1 hour ago

1

2

3