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

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

# 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: 1710

.

+ 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

Is it compulsory to convert time from min to sec or its ok with the minute also? Please help

No, Answer same he arha hai aap convert karen ya na karen.

CS614 Assignment#03 Solution Spring 2019

CS614 Assignment#03 Solution Spring 2019

## Latest Activity

qasim jalal joined + M.Tariq Malik's group

### MTH405 Elementary Topics in Pure Mathematics

29 minutes ago
qasim jalal joined + M.Tariq Malik's group

### MCD401 Camera basics, principles and practices

45 minutes ago
qasim jalal, Laiba, Momina saddiqui and 12 more joined Virtual University of Pakistan
46 minutes ago
haniya liked ٹمبکٹو's discussion گناہ
53 minutes ago
haniya replied to ٹمبکٹو's discussion گناہ
53 minutes ago
1 hour ago
+"Buzz Off"++ replied to + ! ! dAd's anGeL ❤️'s discussion -_-
2 hours ago
+"Buzz Off"++ liked + ! ! dAd's anGeL ❤️'s discussion -_-
2 hours ago
+ ! ! ! ! ! ! Sm!Le ( 10 ) replied to ٹمبکٹو's discussion گناہ
2 hours ago
+ ! ! ! ! ! ! Sm!Le ( 10 ) updated their profile
2 hours ago
Wania Rubab and ateeqa are now friends
2 hours ago
Haleema Nasir Mughal replied to ٹمبکٹو's discussion حاضری
2 hours ago

1

2

3