Case Studio is a professional and intuitive database-designing tool, which allows you to visually create Entity Relationship Diagrams (ERD) for various database systems. It includes full support of the following databases: Oracle, IBM DB2, MS SQL, InterBase, MySQL, PostgreSQL, Sybase ASE, MS Access, Ingres, Informix, and several others. When creating ERD, the program considers individual database options such as referential integrity, constraints, domains, triggers, user permissions, and so on. Key features also include universal reverse engineering, which allows you to reverse-engineer already existing database structure; a version manager; creation of very detailed HTML and RTF reports.
Version 2.12 includes: synchronization between FKs NOT NULL constraint and relationships partiality state, setting of Default data type for individual models, version comparison RTF report, model verification for InterBase 7, 6 SQL3 and 6 SQL1.