We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

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.

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

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

Views: 1789

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

+M.Tariq Malik liked Fatima's discussion mgt503
5 hours ago
+M.Tariq Malik liked Fatima's discussion MGT503 short notes
5 hours ago
MUHAMMAD IHSAN ULLAH and maria shams are now friends
5 hours ago
Fatima posted discussions
5 hours ago
5 hours ago
+M.Tariq Malik posted discussions
6 hours ago
6 hours ago
нαρρү cнαη∂α] •._.•´¯)'s discussion was featured

6 hours ago

1

2