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 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?

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

ayesha joined + M.Tariq Malik's group

53 minutes ago
1 hour ago
+ ՏhehαrZααD + liked Biya's discussion Surah Yusuf 12:64
1 hour ago
+ ՏhehαrZααD + replied to Biya's discussion Surah Yusuf 12:64
1 hour ago
+ ՏhehαrZααD + liked Biya's discussion SURAH AZ-ZARIYAT 51:58
1 hour ago
1 hour ago
+ ՏhehαrZααD + liked Biya's discussion Surah-Al-Mulk 67 : 1 . 2
1 hour ago
1 hour ago
1 hour ago
+ ՏhehαrZααD + replied to Biya's discussion Surah YUNUS / AYAT 38
1 hour ago
ZIDI MONDA updated their profile
2 hours ago
M Attiq updated their profile
2 hours ago
2 hours ago
2 hours ago
2 hours ago
2 hours ago
Biya liked + ! ! ! ! ! !blaire's blog post غار سجدہ
2 hours ago
2 hours ago
Biya liked + !ѕιмρℓє ¢н's discussion choti choti khwahishein....
2 hours ago
Biya replied to Whispering Soul's discussion Kabi kabi...
2 hours ago

1

2

3