Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions