Modeling the data shows the relationships between tables. Bennyhoff Products and Services frequently uses Navicat to model Datawarehouse’s and complex reports. This product costs either $22 per month on a subscription bases or $367 on a one-time purchase. There is a free or express version that is available. The express version is limited but allows for clients to view and approve my work. I usually design a model for a client and send them the Navicat file and a link to the free version.
From The Navicat Website:
Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more. Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click. Navicat Data Modeler supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite.
