CS614 Data warehousing Assignment No.2 Solution Fall Semester 2013

[Vuhelper]

CS614 Data warehousing Assignment No.2 Solution Fall Semester 2013.


Data warehousing (CS614)
Assignment # 2 (Graded)
Total marks = 20
Deadline Date = 28-11-2013

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 Two (2) pages.
5) This is graded assignment and marks will be included in final Grading (CGPA)


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
Reference:
Please refer the case study given in assignment no. 1

Question#1:

Consider the following Many-to-Many relation between “Project” and “Developer”:

Each project is assigned many developers and each developer may be assigned many projects at the same time. Apply the “Table Collapsing” technique to denormalize this relation.

Question#2:

Consider the following One-to-Many relation between “Project Backlog” and “Story”:

“Project Backlog” has many stories and each story belongs only to one “Project Backlog”. Apply the pre-joining table collapsing technique to denormalize the relation.

[Xpert]

If you want to get the full and final discussion. Then start discussion here ask answer i will help you out and will provide the diagram with logic.

[Xpert]

Ok for the first question as we know collapsing tables meaning to denormalization techniques is combining of one to one relationships we have two table in this situation one that one project is assign to many developers and one developer is working on many projects. So a single row has the multiple coloum which is the key point to denormalization of the table.