When we go through the different approaches available to design a database, we can identify top-down
design as a one main approach available for database design. When we go through the different approaches available to design a database, we can identify top-down
design as a one main approach available for database design. This approach begins by identifying the different entity types and the definition of each entity's attributes.
Mainly top-down database approach starts with the development of data model or schemas that contains high-level abstractions. This approach helps database designers to get a good overview over the customers business, the business practices, business rules and reporting requirements.
We can say that Entity relationship diagram or model(ERD) is an example of top-down approach and is more suitable for the design of compiled databases. The process of specialization to refine an entity type into subclasses is another example of the top-down database design approach
When we go through the data model we can identify different types of advantages. We can summarized the main advantages of this as follows,
visualization of the system
Aids to identify the system
Aids to represent the idea behind the system