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.
Solution: Three tables are created here.
->project_id number primary key,
->project_dev_id number primary key,
-> project_id number,
FOREIGN KEY (project_id ) REFERENCES project_table(project_id )
FOREIGN KEY (developer_id ) REFERENCES developer_table(developer_id )
->developer_id number primary key,
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.
Solution: Two tables are created here.
story_id number primary key,
project_backlog_id number primary key,
story_id number FOREIGN KEY (story_id ) REFERENCES project_backlog_table(story_id )DOWNLOAD SOLUTION HERE