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

1.7kviews

written 7.0 years ago by

teamques10 ★ 69k

modified 2.7 years ago by

sagarkolekar ★ 11k

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.

distributed databases

ADD COMMENT EDIT