Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Horizontal Fragmentation 10 Giventhefollowingrelationaldatabase: Employees EmpNo EmpName Salary E1 Federer 20000 E2 Klum 10000 E3 Spears 12000 E4 Montoya 6000 E5 Beckham 15000 E6 Lopez
Horizontal Fragmentation 10 Giventhefollowingrelationaldatabase: Employees EmpNo EmpName Salary E1 Federer 20000 E2 Klum 10000 E3 Spears 12000 E4 Montoya 6000 E5 Beckham 15000 E6 Lopez 18000 ProjectAssignments EmpNo ProjNo MonthsSpent E1 P1 3 E2 P2 4 E2 P4 2 E3 P3 8 E4 P1 E5 9 E6 P4 4.5 m 6 Projects ProjNo ProjName P1 Training P2 Advertising P3 Management P4 Customer Support Location Budget Geneva 98000 Geneva 72000 Munich 150000 Zurich 120000 Typicalqueriesfromapplicationsare: Atthecontrollingdepartmentlocated in Geneva: A1 SELECT P.ProjNo, P.Budget, PA.EmpNo, PA.MonthsSpent FROM Projects P, ProjectAssignments PA WHERE P.ProjNo=PA.ProjNO AND P.Budget 11500 At the human resource department located in Munich: A3 SELECT * FROM Employees E A4 SELECTE.*, PA.MonthsSpent FROM Employees E, ProjectAssignments PA WHERE E.EmpNo=PA.EmpNo At the sales coordination department located in Zurich: A5 SELECT * FROM Projects WHERE Location! = "Geneva" a) What are the corresponding fragments of the two relations Employees and Projects? c) How would you fragment Project Assignments horizontally
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