CASE Studio 2
Database design
Reverse engineering
SQL code generation
HTML and RTF Reports
Maintenance
Customization
Data flow diagrams
Supported databases
Full & Lite versions
Version differences
General
Home
Purchase
Downloads

CASE Studio 2 - database design tool

This data modeling tool is an ideal choice for companies and developers who want to work with their own databases comfortably. Key features include:
  • Entity relationship diagrams
  • Support for various databases
  • Generation of SQL (DDL) scripts
  • Reverse engineering
  • Generation of detailed HTML and RTF documentation
  • Export into XML format etc...

Entity relationship diagrams - ER diagrams

Using the graphically very well arranged Entity Relationship Diagrams (ER Diagrams) you can easily create and maintain your database structures. In your models you will have all the entities, attributes, domains, primary keys, foreign keys, constraints, relationships, also notes and other physical and logical data, laid-out in a transparent order.

While creating models you will have a perfect view of all database elements. You can simply set the values of all attributes, types of relationships and other criteria, as for example indexes, etc.

How can it help me?

The most significant benefits are related to the following areas:
  • Professional and faster development
  • Productivity improvements
  • Fewer faults in development
  • Very efficient maintenance
  • Work with already existing database structures
  • Testing of the consistency and validity of your models
  • Generation of detailed HTML and RTF documentation

Supported databases

Triggers, Procedures, Views....

CASE Studio 2 supports also Functions, Procedures, Triggers, Views, Packages, Package bodies, Object types, Object type bodies, Sequences and Synonyms as Text Objects (depends on target database).

You can create also patterns for triggers, views and procedures. Of course, Text Objects could be reverse engineered from already existing database structures.

Tip

Right click the desktop area and select the "Straight Relationship Lines" item to draw straight relationship lines.

What Do They Say ?

Having worked with CASE design tools for over 10 years I can say your product's price performance ratio is definitely Tops in the market today. Keep up the good work!
Steve Martin
P.Eng., Senior Analyst, Ontario Energy Savings Corp.

Entity Relationship Diagram - logical view
ERD - logical view

Entity Relationship Diagram - physical view
ERD - physical view

ER Diagram - entity
Entity

ER Diagram - attribute
Attribute

ER Diagram - relationship
Relationship

ER Diagram - text objects
Text objects

ER Diagram - text objects Oracle
Text objects Oracle



For further information contact enquiries@advantages.co.nz

   
© 2008 Advantage Software Limited   Return to top