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.
CS508 Quiz 2 Solution and Discussion
CS508 - Modern Programming Languages11
MGT201 Assignment 1 Solution and Discussion
MGT201 - Financial Management6
CS202 Assignment 3 Solution and Discussion
CS202 - Fundamentals of Front End Development6
CS601 Assignment 3 Solution and Discussion
CS601 - Data Communication5
CHE301 Assignment 2 Solution and Discussion
CHE301 - Analytical Chemistry & Instrumentation5
CS204 Assignment 3 Solution and Discussion
CS204 - Cyber Law4
CS304 Assignment 3 Solution and Discussion
304 - Object Oriented Programming4
BT605 Assignment 2 Solution and Discussion
BT605 - Biosafety & Bioethics4
UNSOLVED CS601 Assignment 1 Solution and Discussion
CS601 - Data Communication3
ENG509 Assignment 2 Solution and Discussion
ENG509 - Morphology and Syntax3
CS402 Assignment 3 Solution and Discussion
CS402 - Theory of Automata3
CS310 Assignment 3 Solution and Discussion
CS310 - Open Source Web Application Development (PHP, PERL, CGI, Mysql)3
CS311 Assignment 3 Solution and Discussion
CS311 - Introduction to Web Services Development3
CS615 Assignment 3 Solution and Discussion
CS615 - Software Project Management3
SOLVED SOC401 Assignment 1 Solution and Discussion
SOC401 - Cultural Anthropology2
CS507 Assignment 3 Solution and Discussion
CS507 - Information Systems2
Do you recommend the pharmaceutical companies in Pakistan to replace the conventional health literacy campaigns with the online health literacy campaigns? Write four logical arguments to prove your point.
MGT602 - Entrepreneurship2
STA643 Assignment 2 Solution and Discussion
STA643 - Experimental Designs2
PSY511 Assignment 1 Solution and Discussion
PSY511 - Environmental Psychology2
SOLVED HRM624 Assignment 1 Solution and Discussion
HRM624 - Conflict Management2