VU Assignment Solution, GDB Solution, Handouts,: 2014

Saturday, December 27, 2014

5 Airbus Jets Make Stunning Formations

Dunya News - 5 Airbus jets make stunning... by dunyanews

DAANISH SCHOOL (Boys) Rahim yar khan Situation Vacant Daanish School (Boys)

Updated Answer Keys The Government of Punjab, School Education Department (Entry Test for the Recruitment of Educators in all Districts of Punjab)

Friday, April 4, 2014

Vendor Item Spreadsheet Project

Thursday, January 23, 2014

CS614 Assignment No.04 (Graded) Due Date: 23-01-2014 please share the solution.

CS614 Assignment No.04 (Graded) Due Date: 23-01-2014

Data warehousing (CS614)
Assignment # 4 (Graded)
Total marks = 20
Deadline Date = 23/01/2014

Please carefully read the following instructions before attempting the assignment.

Rules for Marking
It should be clear that your assignment would not get any credit if:

The assignment is submitted after due date.
The submitted assignment does not open or file is corrupt.
The assignment is copied. Note that strict action would be taken if the submitted assignment is copied from any other student. Both students will be punished severely.

1) You should consult recommended books to clarify your concepts as handouts are not sufficient.
2) You are supposed to submit your assignment in .doc format. Any other formats like scan images, PDF, Zip, rar, bmp, docx etc will not be accepted
3) You are advised to upload your assignment at least two days before Due date.
4) This assignment file comprises of Three (3) pages.
5) You can also discuss the assignment in upcoming skype session.

Important Note:

Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the deadline to avoid inconvenience later on.

For any query please contact: CS614@vu.edu.pk
Table: Developer

DeveloperID
DeveloperName
DeveloperEmail
DeveloperJoiningDate
DeveloperCurrentSalary

01
Ali
…
01/01/2011
60000
02
Waseem
…
13/01/2011
55000
03
Waqas
…
20/04/2011
51000
04
Rashid
…
01/03/2011
58000
05
Qamar
…
01/04/2011
59000
06
Altaf
…
01/02/2011
53000
07
Akram
…
28/03/2011
56000
08
Wasif
…
07/02/2011
54000
09
Basit
…
25/08/2011
42000
10
Amir
…
24/07/2011
44000
11
Latif
…
01/08/2011
47000
12
Raza
…
01/07/2011
43000
13
Kashif
…
07/06/2011
46000
14
Noman
…
01/05/2011
49000
15
Naveed
…
01/06/2011
48000
16
Atif
…
11/05/2011
45000
17
Raheel
…
01/09/2011
30000
18
Sohail
…
02/09/2011
29000
19
Ibrar
…
01/10/2011
21000
20
Jawad
…
04/11/2011
26000
21
Bilal
…
10/10/2011
25000
22
Danish
…
01/11/2011
22000
23
Jameel
…
26/12/2011
28000
24
Khuram
…
01/12/2011
23000

Table: ProjectBacklog

BackLogID
CreatedBy
DateCreated
ProjectID

BLG001
Ali
24/03/2012
INV785
BLG113
Asim
07/04/2013
MIS341
BLG124
Waseem
01/02/2012
DSS478
BLG111
Atif
05/07/2013
MIS123
BLG125
Aslam
04/12/2013
WWW110
BLG144
Rashid
25/09/2012
INV541

Table: Story

StoryID
StoryName
StoryDescription
StoryStatus
BackLogID

SRCH98
Search_Inv
User should be able to search any inventory item
IP
BLG001
LGN12
Login
User should be able to login
IP
BLG124
DRW17
Draw_SH
User should be able to physically draw shape
C
BLG113
LGOUT145
LogOut
User should be able to logout
IP
BLG001
DISPM76
Disp_Menu
A popup menu should be displayed on right click
C
BLG111
SESSM23
Session_Maintain
Session should be maintained properly
IP
BLG124
UNDO25
Undo
Undo the latest task
D
BLG125
REDO45
Redo
Redo undone task
IP
BLG144

Question No. 1

Create and pictorially (graphically) show the dense index on DeveloperID column in Developer table.

Question No. 2

Create and pictorially (graphically) show the two-level sparse index on DeveloperJoiningDate column in Developer table

Question No. 3

Consider the following query:

“Select ProjectBacklog.BackLogID, ProjectBacklog.DateCreated, Story.StoryID, Story.StoryName from ProjectBacklog, Story where ProjectBacklog.DateCreated < ‘31/12/2012’ and Story.StoryStatus = ‘IP’ and ProjectBacklog.BackLogID = Story.BackLogID”

Suppose this query is executed using Naive Nested-Loop join (i.e. there is no index created on both ProjectBacklog and Story tables). Mention that which table should be the Outer table to get minimum I/O by manually calculating the cost in both cases i.e. when “ProjectBacklog” is outer table and when “Story” is outer table.

Note: You also need to mention the calculations in your solutions.

MGT610 GDB Solution & Discussion Last Date: 24-01-2014

MGT610 GDB Solution & Discussion Last Date: 24-01-2014

Topic: “Impact of Business Model on Communitarian Ethics”
Learning Objectives:
1. To make the students learn about sweetshop business model and its ethical implications for a business.
2. To make the students learn about need for business differentiation and competitive advantage based on ethical practices.
Learning Outcomes:
1. Students would be able to know how business practices can impact communitarian ethics.
2. Students would be able to think and give suggestions for developing a business model in line withbusiness ethics.
Context
Sweetshop is the term used for those manufacturing units where there is no regulatory check for child labour / bonded labour and where working conditions are hazardous. Sweetshop manufacturers pay very low wages to the workers and don’t care for safety standards or working environment. Concept of sweetshops is an old one for most of the developed countries of Europe and America. But this concept is still in practice in some of the Asian and under developed African countries. Some of the major manufacturing companies have high manufacturing cost in their original countries but through sweatshops in Africa and some of the Asian countries, those companies significantly reduced their cost. These low cost manufactured items in sweetshops are then exported to parent companies that earn high profit margin in developed countries.
Some of the famous multinational companies that faced allegation of sweetshop business model in low cost Asian and African countries also include Nike Inc, when it produced low cost shoes in China, South Korea and Taiwan. Although Nike defended it position by stating that it had no control on sub-contractors. Some of the garment factories working in Bangladesh like Tazreen factory where almost 100 people were killed in 2012 due to fire incident have faced the allegation of sweetshop business model. There are many other examples of organizations that followed sweetshop business model in low income countries to cut down their business cost.
Case
Mr. Ali is the owner of a small garments factory where he has also hired local workers for handmade garments. Factory operates with the name of “Sun Garments”. Factory site is located in a far off area where there is very little legal and regulatory check on business practices. Workers get below average salaries in the working conditions that cannot be termed ideal with respect to safety standards. Following of such a sweetshop business model saves business cost and increases margin of profit. Mr. Ali exports most of his garments to some of the famous brands in Europe and earns huge profit margin. Most of the competitors for Sun Garments are also following a similar sweetshop model of business to cut down their business cost.
Although following of this sweetshop model earns good revenue for Mr. Ali along with employment for local residents. But even then; Mr. Ali does not want to enhance investment on the betterment of human resource of Sun Garments to save extra margin of his business profit.
Question:
Do you think that by following sweetshop model, Sun Garments is violating communitarian ethics while its direct competitors are also following the same business model? Give five suggestions to Sun Garments for bringing its business in line with business ethics.

MGT613 - Production / Operations Management GDB # 2 Fall 2013 Discussion and Solution Start Date: Jan 21, 2014 End Date: Jan 23, 2014

RODUCTION/OPERATIONS MANAGEMENT (MGT613)

MARKS 20

Total quality management (TQM) and Six Sigma are two concepts in the market which mainly focuses on the quality of the products or services. Six Sigma is comparatively a new concept in the market and may not be a replacement to the Total Quality Management (TQM) yet both have many similarities.

Being a production/ operations manager which concept do you think deeply focuses on the quality? Also mention the type of business you want to start and which quality standards you will maintain for your proposed business under TQM or Six Sigma or you will focus on both.

Note: Your answer should be short and it can be in bullet form. Copying or cheating any part of your answer from any source or from each other will be awarded “Zero” marks. You have to mention your own type of business and quality standards for that specific type of business.

Important Instructions:

Your discussion must be based on logical facts.
The GDB will open and close on above specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
Use the font style “Times New Roman” and font size “12”.
Your answer should be relevant to the topic i.e. clear and concise.
Do not copy or exchange your answer with other students. Two identical / copied comments will be marked Zero (0) and may damage your grade in the course.
Books, websites and other reading material may be consulted before posting your comments; but copying or reproducing the text from books, websites and other reading materials is strictly prohibited. Such comments will be marked as Zero (0) even if you provide references.
You should post your answer on the Graded Discussion Board (GDB), not on the Moderated Discussion Board (MDB). Both will run parallel to each other during the time specified above. Therefore, due care will be needed.
Obnoxious or ignoble answer should be strictly avoided.
You cannot participate in the discussion after the due date via email.
Questions / queries related to the content of the GDB, which may be posted by the students on MDB or via e-mail, will not be replied till the due date of GDB is over.
For planning your semester activities in an organized manner, you are advised to view schedule of upcoming Assignments, Quizzes and GDBs in the overview tab of the course website on VU-LMS.

Note related to load shedding: Please be proactive

Dear students!

As you know that Pre Mid-Term semester activities have started and load shedding problem is also prevailing in our country. Keeping in view the fact, you all are advised to post your activities as early as possible without waiting for the due date. For your convenience; activity schedule has already been uploaded on VULMS for the current semester, therefore no excuse will be entertained after due date of assignments, quizzes or GDBs.

Assignment No. 04 SEMESTER Fall 2013 CS301- Data Structures Total Marks: 25 Due Date: 29/01/2014

	Assignment No. 04 SEMESTER Fall 2013 CS301- Data Structures		Total Marks: 25 Due Date: 29/01/2014
*Instructions* Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit (zero marks) if: Ø The assignment is submitted after due date. Ø The submitted assignment file is not in .doc or .docx format. Ø The submitted assignment file does not open or corrupted. Ø The assignment is copied (from other student or ditto copy from handouts or internet). *Uploading instructions* For clarity and simplicity, You are required to Upload/Submit only one MS word file which will contain solutions of all the questions. Ø Don’t wait for grace day. Grace Day is given only if there is problem with LMS on due date. Submit your solution within due date. Ø Note that no assignment will be accepted through email if there is any problem on grace day. Note: It is recommended to use Microsoft Word for solution of assignment. *Objective* The objective of this assignment is o To make you familiar with traversing AVL tree, threaded binary tree and construction of (min and max) heap. For any query about the assignment, contact at cs301@vu.edu.pk GOOD LUCK
		Marks: 25
Question 1(a): Marks 2 Find the pre-order traversal of AVL tree given in solution of assignment 3. Question 1(b): Marks 8 Construct min heap from data traversed in question 1(a). Question 2(a): Marks 2 Find the post-order traversal of AVL tree given in solution of assignment 3. Question 2(b): Marks 8 Construct max heap from data traversed in question 2(a). Question 3: An AVL tree is given in the solution file of assignment 3. Convert that AVL tree into a threaded binary tree and also use dummy node in this threaded binary tree. Marks 5 Solution Guidelines: Use assignment 3 solution file for AVL tree while finding pre-order, post-order traversal or constructing threaded binary tree. In question 1(b) show final tree of min heap and status of array. In question 2(b) show final tree of max heap and status of array. While building max or min heap tree, read traversed values from left to right.
Lectures Covered: This assignment will covers lectures # 23 - 31 Deadline: Your assignment must be uploaded / submitted on / before, Wednesday January 29, 2014.

ORGANIZATIONAL BEHAVIOUR (MGT502) fall 2013 Graded Discussion Board No. 02 Due Date: January 22, 2014

fall 2013

Graded Discussion Board No. 02

ORGANIZATIONAL BEHAVIOUR (MGT502)

Due Date: January 22, 2014 Marks: 20

Topic: Work-family life Conflict Lesson 23-28

Point of Discussion (POD)

The concept of work-family conflict (WFC) is defined as a role conflict caused by taking on too many responsibilities at work and home for employees. WFC is the negative interaction between work and family and on the other hand balanced work-life have positive relation with them. Organizational studies have demonstrated that work-life balance practices can improve organizational performance and commitment and increase job satisfaction.

How organization can minimize the conflict role in work family life. Discuss with solid points.

Note:

For acquiring the relevant knowledge, do not rely only on handouts but also watch the course video lectures and read additional material available online or in any other mode.