Explain Top-down & bottom-up Design Process for Distributed Database.

Explain Top-down & bottom-up Design Process for Distributed Database.  OR Design Strategies in Distributed Database Management System (DDBMS).

Database Design Strategies:

There are two approaches for developing any database, the top-down method and the bottom-up method. While these approaches appear radically different, they share the common goal of utilising a system by describing all of the interaction between the processes.

1. Top-down  design process
2. Bottom – up design process

1. Top – down design process

The top-down design method starts from the general and moves to the specific.

In other words, you start with a general idea of what is needed for the system and then work your way down to the more specific details of how the system will interact. 

This process involves the identification of different entity types and the definition of each entity’s attributes.

2. Bottom – up design process

The bottom-up approach begins with the specific details and moves up to the general. 

This is done by first identifying the data elements (items) and then grouping them together in data sets. 

In other words, this method first identifies the attributes, and then groups them to form entities.