CS614 Assignment no. 02 Solution Fall 2016

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 Question 2 Solution:

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.