Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE SALARY DNO FNAME EMP ID MGR_ID LNAME BDATE ADDRESS DEPARTMENT DNAME DNO MGR_ID MGR_STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PLOCATION DNUM PNAME PNO WORKS ON EMP ID PNO HOURS PAY_RATE
To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application information:
App1 : Compute payment = HOURS * PAY_RATE for every employee working in a “NEW YORK” project.
App2 : Compute payment for every employee working in a “PARIS” project.
App3 : Find the basic salaries of mangers of departments that have projects in “NEW YORK” or “TOKYO”.
App4 : Find the salaries of mangers of departments that have projects in “PARIS” and “TOKYO”.
App5 : Find the salaries of employees working in departments in “PARIS” with monthly basic salary < 100000”.
App6 : Find the names of employees in “HEAD_OFFICE” department.
a) Define a set of simple predicates.
AS YOU CAN Answer in details
Step by step
Solved in 3 steps
