1
1.3kviews
Consider following global schema of an company database who keep track of companys employees, department and projects.

Consider following global schema of an company database who keep track of company’s employees, department and projects.

enter image description here

a) Perform primary Horizontal fragmentation(PHF) of relation PROJ with pname and budget of projects given their number issued at three sites and access project information according to budget one site accesses <= 200000 other accesses> 200000

b) Explain how the above resulting PHF fulfill the correctness rules of fragmentation.

c) Perform Derived Horizontal Fragmentation (DHF) of relation EMP with respect to ‘PAY’ (p1:sal>30000 and p2:sal<= 30000)

d) Explain how the above resulting DHF fulfill the correctness rules of fragmentation.

Please log in to add an answer.