Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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 at location NEW YORK : Compute payment = HOURS * PAY_RATE for every employee working in a NEW YORK project.

App2 at location PARIS : Compute payment for every employee working in a PARIS project.

App3 at location ROME : Compute payment for every employee working in a ROME project.

App4 at location TOKYO : Compute payment every employee working in a TOKYO project.

App5 at NEW YORK : Find the basic salaries of mangers of departments that have projects in NEW YORK or TOKYO.

App6 at TOKYO : Find the salaries of mangers of departments that have projects in PARIS and TOKYO.

App7 at PARIS : Find the salaries of employees working in departments in PARIS with monthly basic salary

App8 at NEW YORK: Find the names of employees in HEAD_OFFICE department.

a) Define a set of simple predicates?

b) Define a set of minterm predicates.?

c) Define fragments at each site using SQL.?

d) Define fragments using relational algebra?

Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE FNAME LNAME EMP_ID BDATE ADDRESS SALARY MGR_ID DNO DEPARTMENT DNAME DNO MGR ID MGR STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PNAME PNO PLOCATION DNUM WORKS ON EMPD 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: Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE FNAME LNAME EMP_ID BDATE ADDRESS SALARY MGR_ID DNO DEPARTMENT DNAME DNO MGR ID MGR STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PNAME PNO PLOCATION DNUM WORKS ON EMPD 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

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

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

How to reverse a Armstrong number by using double linked list ?

Answered: 1 week ago