CS614 Data warehousing Assignment No.2 Solution Fall Semester 2013

[Vuhelper]

View more random threads:

• FIN621 Financial Statement Analysis Assignment No.1...
• PHY301 Circuit Theory Assignment No .3 Solution Fall 2013
• Assignment No. 03 Semester: Spring 2013 Computer Network-...
• mcm515 radio news reporting assignment no 2 solution fall...
• ENG201 Technical and Business English Writing Online Quiz...
• ACC501 Business Finance Assignment No.2 Solution Spring...
• CS610 Computer Network Assignment No.02 Fall 2013
• CS506 Web Design and Development Assignment 1 Fall semester...
• CS504 Software Engineering - I Assignments No. 2 Dec 11,...
• Solution Assignment # 01(MTH 101) May 3,2010

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.

Sponsored Links

[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.