AllFusion ERwin Data Modeler 7.3 (ERwin) ERwin Validator 7.3 .19

How to Use AllFusion ERwin Data Modeler 7.3 (ERwin) and ERwin Validator 7.3 .19 to Design and Validate Data Models

AllFusion ERwin Data Modeler 7.3 (ERwin) is a powerful tool for designing and documenting data models for various databases and platforms. ERwin allows you to create logical and physical data models, generate database scripts, reverse engineer existing databases, and compare and synchronize data models.

ERwin Validator 7.3 .19 is a companion tool that helps you validate your data models for consistency, completeness, and quality. ERwin Validator can check your data models for errors, warnings, and best practices, and generate reports and recommendations for improvement.

In this article, we will show you how to use ERwin and ERwin Validator to design and validate data models for a sample project. We will assume that you have installed both tools on your computer and have a valid license key.

Step 1: Create a New Data Model in ERwin

To create a new data model in ERwin, follow these steps:

Launch ERwin and click on File > New > Model.

Select the database platform and version that you want to use for your data model. For this example, we will use Oracle Database 11g.

Enter a name and description for your data model and click OK.

A blank data model will appear on the screen. You can use the toolbar, menu, or right-click options to add entities, attributes, relationships, domains, and other objects to your data model.

You can also use the Model Explorer window to view and manage the objects in your data model.

Step 2: Design Your Data Model in ERwin

To design your data model in ERwin, follow these steps:

Add entities to represent the main concepts or objects in your project. For this example, we will add entities for Customer, Order, Product, Category, and Supplier.

Add attributes to each entity to represent the properties or characteristics of the entity. For this example, we will add attributes such as Customer ID, Name, Address, Phone, Email, Order ID, Date, Total Amount, Product ID, Name, Price, Quantity, Category ID, Name, Description, Supplier ID, Name, Contact Person, Phone, Email.

Add primary keys to each entity to uniquely identify each instance of the entity. For this example, we will use Customer ID for Customer entity, Order ID for Order entity, Product ID for Product entity, Category ID for Category entity, and Supplier ID for Supplier entity.

Add foreign keys to each entity to establish relationships between entities. For this example, we will add foreign keys such as Customer ID in Order entity to link it with Customer entity, Product ID in Order entity to link it with Product entity,

Add relationships between entities to show how they are related to each other. For this example,

we will add relationships such as one-to-many between Customer and Order entities,

many-to-many between Order and Product entities,

one-to-many between Product and Category entities,

one-to-many between Product and Supplier entities.

Add domains to define common data types and formats for attributes. For this example,

we will add domains such as Integer for numeric attributes,

Varchar2(50) for string attributes,

Date for date attributes.

Assign domains to attributes to apply the data types and formats defined by the domains. For this example,

we will assign Integer domain to Customer ID,

Order ID,

Product ID,

Category ID,

and Supplier ID attributes,

Varchar2(50) domain to Name,

Address,

Phone,

Email,

Contact Person attributes,

Date domain to Date attribute,

and so on.

You can also add other objects such as indexes,

triggers,

stored procedures,

views,

and user-defined types to your data model as per your requirements.

Step 3: Validate Your Data Model in ERwin Validator

To validate your data model in ERwin Validator,

follow these steps:

Launch ERwin Validator and click on File > Open > Model.

Select the data model that you want to validate and click Open. a474f39169