CS614 Assignment 1 Spring 2023 – Assignments – Solution VU

Assignment No. 1(Graded)

Semester Spring 2023
Data Warehousing– CS614

Total Marks: 20

Due Date: 24-05-2023

Objective:

This assignment has been designed to develop your ability about basic data warehouse and different issues related to DWH. 

Instructions:

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

1.      The assignment will not beaccepted 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 awardedto the assignment if copied (from other students, internet or any source).

5.      Zero marks will be awardedto the assignment ifthe Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at [email protected]

Please do not post queries related to assignment on MDB.

Note:The assignment covers lectures 1-10.

Question 1  (Marks 10)                                                  

Suppose that you are the data analyst on the project team building a data warehouse for an insurance company. List at least three data sources from which you will bring the data into your data warehouse?

Question 2  (Marks 10)

Data warehouse systems often have complexity issues due to many business requirements. Technical complexity issues arise from three areas: sourcing issues, transformation issues and target issues.

Write at least two examples of each (Not more than one line for each).

Note: Deadline for assignment submission is 24 May 2023.

Wish you best of Luck!