Designing databases can sometimes benefit from a visual approach, and this is exactly where diagramming software can prove its utility. DeZign for Databases was designed specifically for such approaches, and it will allow you to easily construct, refine, and structure logical models for your SQL databases.
The app comes equipped with a diagram editor that facilitates adding objects, corresponding relationships, as well as classes and other relevant aspects. Tabular data, attributes, indexes and more, are all addressed and configurable.
Features a modular design, which allows for a flexible diagram creation approach, and offers a myriad of diagramming, notation, and ER-modeling tools
The design of the application accounts for enhanced functionality, and I really enjoyed its modular nature. Creating and customizing diagrams is easy, and this is at the core of the database design principle behind the app.
Support for a very wide range of elements and objects is provided, as well as relationship types, and by relying on the entity relationship diagrams you will be able to basically graphically design your databases.
Either start from scratch or connect to your preferred database, perform syncs and comparisons in model-to-mode
I also liked the fact that the app allows you the freedom of choice in the design process, and it will enable you to either start from scratch, or connect to an existing database and in this regard the app features support for a wide range of databases, more than 15, ranging from Oracle and al the way to MySQL and PostgreSQL.
Last but not least, in terms of databases and models, you will be able to perform a range of bi-directional comparisons and syncs, for a range of scenarios, such as model-to-database, model-to-script, database-to-model, and more.
Excellent database designer, which relies on diagramming tools and offers lots of versatility and reliability
This software is a powerhouse when it comes to designing and editing databases using diagrams. It will allow you a great deal of control across the parameters and elements that constitute the visual diagram components, as well as their corresponding database objects and their relationships.