CS614 Data Warehousing Assignment No. 02 Semester Fall 2013 Due Date 28-11-2013

[vuassignments]

[B]


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.


  Untitled.png (Size: 3.87 KB / Downloads: 541)

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.


  Untitled.png (Size: 3.77 KB / Downloads: 549)

[/B]

Best Of Luck