Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.

Abstract

This paper describes a tool that supp orts the design and redesign of relational databases The tool produces optimized relational representations of entity relationship ER schemas and is implemented using Informix as its target database management system DBMS The tool operates in two phases In the first phase it receives as input an ER schema and generates a list of commands to implement the corresponding Informix schema In the second phase it receives a list of redesign commands specifying changes to the ER schema and generates a redesign plan to reestructure the database accordingly An example illustrates the use of the tool.