Select Your Subject Code

CS - Computer Science MGT MTH ECO ENG STA PAK PHY ACC
CS001 CS408 CS602 CS619 CS710 CS724 MGT101 MGT501 MGT610 MTH001 MTH603 ECO401 ENG001 STA301 PAK301 PHY101 ACC311
CS101 CS410 CS604 CS701 CS711 CS726 MGT201 MGT502 MGT611 MTH100 MTH201 ECO402 ENG101 STA630 PAK302 PHY301 ACC501
CS201 CS501 CS605 CS702 CS712 CS305 MGT211 MGT503 MGT613 MTH101 MTH203 ECO403 ENG201 STA730


CS301 CS502 CS606 CS703 CS713 CS411 MGT301 MGT510 MGT619 MTH202 MTH311 ECO404 ENG301



CS302 CS504 CS607 CS704 CS716 CS412 MGT401 MGT520 MGT620 MTH301 MTH502 ECO406 ENG401



CS304 CS506 CS609 CS706 CS718 CS413 MGT402 MGT601 MGT703 MTH302
ECO704




CS401 CS507 CS610 CS707 CS720 CS509 MGT404 MGT602 MGT704 MTH401
ECO501




CS402 CS508 CS614 CS708 CS721 CS621 MGT411 MGT603 MGT705 MTH501






CS403 CS601 CS615 CS709 CS723 CS622 MGT501 MGT604 MGT711 MTH601

CS614 Assignment no. 02 Solution Fall 2016

By:


CS614 Assignment no. 02 Fall 2016

Here is the Complete CS614 Assignment No. 02 Solution and discussion of Fall 2016. CS614 Assignment Due Date is 08-12-2016.


Data Warehousing– CS614 
Assignment: Graded
Semester Fall 2016 
Total Marks: 20
Due Date: 08-12-2016


Also Read: financial accounting MGT101 Solved Papers

CS614 Assignment Objective:

This assignment has been designed to develop your understating of Star schema and Snow-flake schema.

CS614 Assignment Instructions:

Please read the following instructions carefully before solving & submitting the assignment:

  1. The assignment will not be accepted after due date.
  2. Zero marks will be awarded to the assignment that does not open or the file is corrupt.
  3. The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
  4. Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
  5. Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file. 
Also Read: ISL 201 Mid term SOlved Papers

For any query about the assignment, contact only at CS614@vu.edu.pk

Please do not post queries related to assignment on MDB.

CS614 Assignment Question 1: 

[10 Marks]

Suppose that you are working as a Software Engineer on a project of developing a data warehouse for a hospital. It should consist of at least three dimensions Doctor, Patient and Time, and the two measures count and charge (fee charged by the doctor from patients for a single visit).

Draw the star schema diagram for the above Data Warehouse.


Also Read: CS 201 all past solved midterm papers 2015

CS614 Assignment Question 2: 

[10 Marks]

Suppose that you are working on a project of developing a Data Warehouse for a University, which should consist of at least four dimensions: student, semester, course, and instructor, and two measures count and avg_grade.

Draw a snow-flake schema diagram for the above Data Warehouse.

Note: Deadline for Assignment submission is 8th December 2016.
Also Read: CS101 Latest Solved MCQs

CS614 Assignment no. 02 Solution

Here is the Solution of CS614 Assignment no. 02 Fall 2016

CS614 Assignment Question 1 Solution:

CS614 Assignment no. 02 Solution of Question no. 1
CS614 Assignment no. 02 Solution of Question no. 1

CS614 Assignment Question 2 Solution:


CS614 Assignment no. 02 Solution of Question no. 2
CS614 Assignment no. 02 Solution of Question no. 2

CS614 Assignment Video Tutorial :

WATCH ONLY 4 MINUTES LONG VIDEO AND SOLVE ASSIGNMENT BY YOURSELF IT IS VERY EASY. ALSO MATCH BOOK STYLE.




You Can Also Download CS614 Solved Mid Term Papers, Short Notes, CS614 Assignment Solutions, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quiz ,CS614 Solved Mid Term Subjective Papers , CS614 Solved Mid Term Objective Papers From This Discussion For Preparation Mid Term Papers of Fall 2015-16.

0 comments:

Post a Comment