This preview shows page 1. Sign up to view the full content.
Unformatted text preview: EMP1 ENO ENAME TITLE E1 J. Doe Elec. Eng E3 A. Lee Mech. Eng. E6 L. Chu Elec. Eng E7 R. Davis Mech. Eng. EMP2 ENO ENAME TITLE E2 M. Smith Syst. Anal. E5 B. Casey Syst. Anal. E8 J. Jones Syst. Anal. According to the rule of completeness, if the relation R is divided into fragments, then every data item in R should exist in at least one fragment. In our case, the relation EMP is fragmented into EMP1 and EMP2 based on the rule defined above. A record for employee E4 (with title=Programmer) is neither in EPM1 nor in EMP2. Hence, this fragmentation doesnt fulfill the completeness rule....
View Full Document
- Spring '09