
Appendix
Solved Examples of B.Tech, M.Tech and M.C.A
Examinations
1. Consider the following PROJECT relation. This relation is fragmented in two fragments namely, P1 and P2 as
given below.
PNO ENO PTYPE PDESC
P001 E001 DEVELOPMENT Proj1
P002 E005 DEVELOPMENT Proj2
P003 E0014 DEVELOPMENT Proj3
P004 E002 MAINTENANCE Proj4
P1:
PTYPE = “DEVELOPMENT”
(PROJECT), P2:
PTYPE = “MAINTENANCE”
(PROJECT)
Show the correctness of the Fragmentation.
[WBUT (MCA)-2008]
Answer:
The correctness of the fragmentation is ensured by three different rules, namely, completeness, reconstruction and
disjointness. According to completeness rule, if a relation is fragmented, ther ...