Xcase facilitates the database analysis and design by providing

• Reverse and Forward Engineering
• Graphic Features
• Customization
• Automation
• Inheritance
• Validity Checks

Complete and accurate reverse and forward engineering capabilities to transform an existing database into clear diagrams.

Comprehensive graphical features to visually manage complexity.

Powerful customization capabilities:

• A fully customizable Data Dictionary which allows you to include user defined attributes.
• Powerful and customizable editors to easily access all the pertinent attributes in the database.

Accurate, time saving automation mechanisms:

• Regardless of whether the target database supports domains, when you create a domain, the attributes of the domain will automatically be propagated to the fields which you assign to the domain.
• The automatic definition of foreign keys as you create relations.
• The automatic building of primary indexes as you flag primary keys.
• The automatic building of foreign indexes as you create relations.
• The automatic cascading of modifications in the parent field to the children fields.

User definable inheritance mechanisms:

Modifications of a field attribute or a domain attribute can be automatically propagated according to the user defined inheritance mechanisms you have set when the modifications must be propagated to foreign keys, view elements, index elements.

Thorough validity checks:

• Automatically check the correctness of database object names according to the rules of the target database.
• Automatically check and signal if you have defined redundant indexes.