www.vustudents.ning.com

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

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

Views: 1840

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

1

## Latest Activity

Heidi Dayne Hanson updated their profile
1 hour ago
Khawir Abbas and Sana Shafaq joined Virtual University of Pakistan
5 hours ago
Abdul Rehman updated their profile
21 hours ago
21 hours ago
Abdul Rehman posted a discussion

### paper

21 hours ago
Maryam joined + M.Tariq Malik's group

### MCM301 Communication skills

yesterday
Maryam joined + M.Tariq Malik's group

### MCM101 Introduction to Mass Communication

yesterday
Maryam joined + M.Tariq Malik's group

yesterday