We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.


+ Link For Assignments, GDBs & Online Quizzes Solution


+ Link For Past Papers, Solved MCQs, Short Notes & More

Assignment No.  3
Semester: Spring 2016

CS614 – Data Warehouse


Total Marks: 20


Due Date:

Thursday, July 28, 2016



Please read the following instructions carefully before submitting assignment:

It should be clear that your assignment will not get any credit if:


  • Assignment is submitted after due date.
  • Submitted assignment does not open or file is corrupt.
  • Assignment is copied (From internet/ to from students).



  • To enhance the communication and presentation skills of the students
  • To understand the difference between Data Warehouse and Data Mart



Assignment Submission Instructions

You have to submit only.zip or .rar file on the Assignments interface of CS614 at VULMS. Assignment submitted in any other format will not be accepted and will be graded zero marks.





As the focus of this assignment is to enhance the communication and presentation skills of the students, so you will have to explain the following questions in your own words. You will make the video recording of yourself while presenting and then submit it through VULMS by following the provided instructions.



You have to present your view about the following task,


In context of data warehouse the word “Data Mart” is used interchangeably with Data Warehouse, Is it Right to use Data Mart instead of Data Warehouse. To clear the rightfulness of this word’s Usage you have to present the Topic “The Data Marts”.



You will have to provide the basic definition and differences only. For example basic definition of a class and object and then a brief explanation of how they differ from each other. The same goes for the given topic as well.


Instructions for the assignment preparation:

  1. You are required to make a presentation file (.ppt or .pptx) for your assignment solution
  2. Presentation will consist of maximum of 4 – 5 slides
  3. First slide will contain your name and VU ID
  4. Remaining slides will contain the solution of the assignment (one topic with short explanation in each slide)
  5. You have to formally present these topics with proper dress code and have to record your video while presenting
  6. You can use any video recording facility such as web cam, camera, mobile phone or etc. for recording of your presentation. See the tutorial “Tips for Recording Videos.mp4” available at download section of VULMS or download from the following URL:


  1. You will start presenting from the first slide by speaking your name and ID, and then the remaining slides.
  2. The recording of your introduction and explanation of the remaining topics should not take more than 4 to 5 minutes
  3. After recording of your presentation, you have to convert your video in “.3gp” format using any video conversion tool to reduce the size of the video file. See the tutorial “Video Compression.mp4” available at download section of VULMS or download from the following URL:     http://vulms.vu.edu.pk/Courses/CS614/Downloads/Soft%20Skill%20Assig...
  4. After converting the video in .3gp format, review your file to verify that audio and video are properly playing. 
  5. Install VLC media player to view your compressed video before uploading on VU-LMS. You can download VLC from http://www.videolan.org/vlc/download-windows.html
  6. It is preferable to use English in your presentation in case of reluctance you can also use Urdu language.
  7. Note that you will record your presentation standing in front of camera.

Instructions for the assignment submission:

  • Compress your video file and presentation file using any compression tool like WINZIP or WINRAR
  • Save your assignment with your ID (e.g. bc020200786.rar)
  • Make sure that size of assignment file should not exceed 30 MB



Your assignment must be uploaded on or before July 28, 2016. We shall not accept your solution through email after the due date.


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Views: 2994


Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

je Bilkul

a.a, plz dosto a jao sub discussion start kr kay ye assignment solve kr lain last day sub solution solution kr rahay hotay hain jin ko aati hay wo guide kr dain plz mil kr ho jaye gi a jayen sub members please

Any one share the ieda of cs614 plzzzzzzzzzzzzzzzzzzzzzzzzzz

Idea is very simple but uski samjh main ana hy js ne baki lectures liay huay hain .

Data Mart

  Departmental subsets that focus on selected subjects.

I try to explain with below diagramLet me recall your some of concept before Datamart

sb se pehly ap k pass production system hota hy jis main all time transaction ho rai hoti hain also called "OLTP"

for example you goto Hyperstart and buy something that data store in OLTP.

from here all data goes to Staging area jaha pe ETL(Extract, Transform, Load) ka process hota hy 

and after ETL your data goes to Datawarehouse.

sb ko itna to andaza hoga k DWH is big big database jis main har department ka data hota hy

now rather directly accessing data from DWH har department apna "Data Mark" bana leta hy isi liay as per definition "  Departmental subsets that focus on selected subjects.

so agar humary pass purchase, sale, inventory k data markts hain aur hum inko ikatha kar dain to wapis DWH ban jaey ga.

now all users, aur devices jin se reporting leni hy wo Data Mart Se commmunicate krain gy. 

For any confusion reply here. 

IMPORTANT : yes sb kuch oper se guzar gaya ho ga agar ap video lec nai lay rahy CS614 k. please ask question only if you are following handout OR videos or you have basic concept of data warehouse working

Additionally this will also help you understanding the cocnept

SK(MS-SE) Please ap apni f.b id tu shair karyn

add me on skype ' vuacademy  ' 

AOA... Please tell me how the assignment of cs614 video and presentation combine... if you complete ur assignment... Thanks

Nothing is need to b combine, record video separatly and make slide sepratetly just combine in zip file and send to your instructor

KOi idea sollution he bata dy notime to listn video lactures :/


Looking For Something? Search Here

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service