A distributed database is one that uses multiple database instances that coordinate with one another to provide a complete logical view of a database schema. Each instance manages fragments, which are subsets of tables that together comprise complete logical tables. Horizontal fragments divide the table by row; vertical fragments divide the table by column; mixed fragments divide the table by row and column.

1. Simulate horizontal fragmentation and defragmentation. Complete the following substeps.a. Create a table that has at least twelve rows and five columns. Make sure the table has a primary key.

b. Define three views that simulate three horizonal fragments based upon some reasonable criteria. Show each views contents.

c. To simulate defragmentation, write and execute a query that combines the views to re-create the original table.

2. In this step, you simulate vertical fragmentation and defragmentation. Complete the following substeps. a. Starting with the same logical table as in #10, define two views that simulate two vertical fragments based upon some reasonable column separation. Show each views contents.

b. To simulate defragmentation, write and execute a query that combines the views to re-create the original table.

3. In this step, you simulate mixed fragmentation. Complete the following substeps. a. Create 6 views, where each view represents a combination of one horizontal and one vertical fragment from #1 and #2. All fragments should be covered by the 6 views. Show each views contents.

b. To simulate defragmentation, write and execute a query that combines the views to re-create the original table.