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

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

Sponsored Links

Best Of Luck