Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Consider relation ASG in Figure 1. Suppose there are two applications that access ASG. The first is issued at five sites and attempts to
2. Consider relation ASG in Figure 1. Suppose there are two applications that access ASG. The first is issued at five sites and attempts to find the duration of assignment of employees given their numbers. Assume that managers, consultants, engineers, and programmers are located at four different sites. The second application is issued at two sites where the employees with assignment duration of less than 20 months are managed at one site, whereas those with longer duration are managed at a second site. Derive the primary horizontal fragmentation of ASG using the foregoing information. EMP ASG ENO ENAME TITLE ENOPNO RESP DUR E1 J. Doe Elect. Eng P1 12 P1 24 E2 M. Smith Syst. Anal. 6 A. Lee Mech. Eng. P2 P3 10 E4 J. Miller Programmer Syst. Anal. E1 E2 E2 E3 E3 E4 E5 E6 P4 48 E5 B. Casey Manager Analyst Analyst Consultant Engineer Programmer Manager Manager Engineer Manager 18 E6 P2 P2 24 L. Chu R. Davis Elect. Eng. Mech. Eng. E7 P4 48 E8 J. Jones Syst. Anal. 36 E7 E8 P3 P3 40 PROJ PAY PNO PNAME BUDGET LOC TITLE SAL P1 P2 P3 P4 Instrumentation Database Develop. CAD/CAM Maintenance 150000 135000 250000 310000 Montreal New York New York Paris Elect. Eng. Syst. Anal. Mech. Eng. Programmer 40000 34000 27000 24000 Figure 1: Database (a) Perform a horizontal fragmentation of relation EMP with respect to {p1, p2}. (b) Explain why the resulting fragmentation (EMP1, EMP2) does not fulfill the correctness rules of fragmentation. (c) Modify the predicates p1 and p2 so that they partition EMP obeying the correctness rules of fragmentation. To do this, modify the predicates, compose minterm predicates and deduce the corresponding implications, and then perform a horizontal fragmentation of EMP based on these minterm predicates. Finally, show that the result has completeness, reconstruction and disjointness properties
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started