CS614 Assignment No.3 Solution and Discussion
Assignment No. 3
Semester: Spring 2019
CS614 – Data Warehousing
Total Marks: 20
August 01, 2019
After completing this assignment the students will be able to:
• Understand parallelism
• Calculate speed-up time for pipelining
• Calculate Costs associated with nested loop joins while indexing is not used
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:
o Assignment is submitted after due date.
o Submitted assignment does not open or file is corrupt.
o Assignment is copied (From internet/ to from students).
o Assignment is submitted other than word format (.doc, .docx).
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.
Answer will be same after convert.
CS606 Assignment 3 Solution and Discussion
CS606 - Compiler Construction48
MTH603 Quiz 1 Solution and Discussion
MTH603 - Numerical Analysis29
CS508 Quiz 2 Solution and Discussion
CS508 - Modern Programming Languages20
ENG101 Assignment 2 Solution and Discussion
ENG101 - English Comprehension10
MTH603 Quiz 2 Solution and Discussion
MTH603 - Numerical Analysis9
PSY610 Assignment 2 Solution and Discussion
PSY610 - Neurological Bases of Behaviour8
CS431 Assignment 3 Solution and Discussion
CS431 - Wireless Communication8
CS314 Assignment 3 Solution and Discussion
CS314 - Introduction to Cellular Networks6
CS315 Assignment 2 Solution and Discussion
CS315 - Network Security6
CS315 Assignment 3 Solution and Discussion
CS315 - Network Security6
SOLVED SOC101 Assignment 1 Solution and Discussion
SOC101 - Introduction to Sociology5
Why http url auto redirect to https?
EDU431 Assignment 3 Solution and Discussion
EDU431 - Test Development & Evaluation5
BT603 Assignment 2 Solution and Discussion
BT603 - Fermentation Technology5
CS605 Assignment 3 Solution and Discussion
CS605 - Software EngineeringII4
BIO204 Assignment 2 Solution and Discussion
BIO204 - Principles of Biochemical Engineering4
CS408 Assignment 3 Solution and Discussion
CS408 - Human Computer Interaction4
PAK301 Assignment 2 Solution and Discussion
PAK301 - Pakistan Studies4
ENG505 Assignmnet 2 Solution and Discussion
ENG505 - Language Learning Theories4
PAD603 Assignment 1 Solution and Discussion
PAD603 - Governance, Democracy and Society4