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.2 (*). Consider relation ASG in Figure 3.3. Suppose there are two ap- plications 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 an 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
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