Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design Issues EMP ASG ENO ENAME TITLE ENOPNO RESP DUR 12 24 E1 E2 E3 E4 E5 E6 E7 6 10 J. Doe Elect. Eng
Design Issues EMP ASG ENO ENAME TITLE ENOPNO RESP DUR 12 24 E1 E2 E3 E4 E5 E6 E7 6 10 J. Doe Elect. Eng M. Smith Syst. Anal. A. Lee Mech. Eng. J. Miller Programmer B. Casey Syst. Anal. L Chu Elect. Eng R. Davis Mech. Eng. J. Jones Syst. Anal. E1 E2 E2 E3 E3 E4 E5 E6 E7 E8 P1 P1 P2 P3 P4 P2 P2 P4 P3 P3 Manager Analyst Analyst Consultant Engineer Programmer Manager Manager Engineer Manager PAY 48 18 24 E8 48 36 40 PROJ PNO PNAME BUDGET LOC TITLE SAL P1 Instrumentation 150000 Montreal Elect. Eng. P2 Database Develop. 135000 New York | Syst. Anal. P3 CAD/CAM 250000 New York | Mech. Eng. P4 Maintenance 310000 Paris Programmer 40000 34000 27000 24000 Fig. 3.3 Modified Example Database Problem 3.5 (**). Given relation PAY as in Figure 3.3, let pi: SAL 30000 be two simple predicates. Perform a horizontal fragmentation of PAY with respect to these predicates to obtain PAY1, and PAY2. Using the fragmentation of PAY, perform further derived horizontal fragmentation for EMP. Show completeness, reconstruction, and disjointness of the fragmentation of EMP
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