Subject: Distributed Database

Topic: Distributed Database Design

Difficulty: High

Using a snapshot of the following centralized schema of a database

Departments(DN,DName, Budget, Location)

Employees( EN, EName, Title,DNo)

Salary (Title, Salary)

a) Show 2 examples of horizontal fragmentation with fragmentation rules.

b) Show 2 examples of vertical fragmentation with fragmentation rules.

c) Show 2 examples of derived fragmentation with fragmentation rules.

d) Demonstrate the correctness of your fragmentation rules.