Erwin Tutorial for Beginners
Updated on 02nd Jul, 21 9144 Views

ERwin:

A leading tool that makes Database Engineers to enter their Entity Relationship (ER) diagrams in a graphical method and generate physical database strategies for common relational database management systems such as Microsoft SQL Server and Oracle is ERwin.

Criteria ERwin
ERwin application Data modeling
ERwin advantages Simple visual interface to manage complex data
ERwin accessibility Simple and user-friendly
 

Go through Intellipaat’s short video on Microsoft SQL Developer Tutorial:

 

ERwin supports a pattern of features of database strategy, which includes modeling of data, forward engineering (It is the process of formation of a database schema and physical database on the basis of a data model), and reverse engineering (It is the process of formation of a data model on the basis of an available database) for a wide-ranging varieties of relational DBMS, including Oracle, Microsoft Access, Sybase, DB2, and many more.

  • Starting with ERwin:

The upper portion of the workspace consists of Menu and Toolbars. The middle portion of the workspace consists of two panes: the model explorer panel and the diagram window. The lower portion contains two windows: first is the action log that shows a log of all alterations made to the data model under design, and second is the advisories panel that shows messages related to actions executed on the data model under design.

There are three model types supported by ERwin which is used by a Database Developer:

  1. Logical: It is a theoretical model that contains entities, attributes, and relationships. This model type is principally at the ER modeling level.
  2. Physical: It is a database-specific model that comprises columns, relational tables, and their associated data types.
  3. Logical/Physical: It is a single model that contains both theoretical-level objects and physical-level tables.
  • Adding Entity Types:

If you want to add an entity type to the database design, either right-click on the ‘Entities’ entry in the model explorer window and select ‘New’ or select the ‘Entity’ icon in the Menus and Toolbars section of the workspace and click on the diagram window panel.

  • Adding Relationships:

ERwin supports three types of relationships, i.e., many-to-many, identifying, and non-identifying. ERwin categorizes the child entity type in a classifying relationship as ‘weak.’ To add a relationship, in the model explorer window, right-click on the ‘Relationships’ entry and select ‘New.’ This will help in creating a new relationship.

Learn new Technologies

  • Forward Engineering:

ERwin offers a dominant feature called forward engineering that permits Database Developers to transform the ER design into a schema generation SQL script for one or more target relational databases. The resulting SQL script is obtained by choosing ‘Tools’, then ‘Forward Engineering’, and then ‘Schema-Generation’ option available in the Menus and Toolbars section and by clicking on the ‘Preview’ button.

  • Supertype/Subtype Example:

ERwin supports the formation of subtype/supertype relationships among entity types. To produce design in ERwin, there are three entity types that need to be created first. After that, one has to click on the subtype button in the Menus and Toolbars section, and then click on the supertype entity in the diagram window. Once that is done, click on the subtype entity in the diagram window. This procedure may be recurrent for adding other subtypes as well.

Course Schedule

Name Date
Data Analytics Courses 2021-11-27 2021-11-28
(Sat-Sun) Weekend batch
View Details
Data Analytics Courses 2021-12-04 2021-12-05
(Sat-Sun) Weekend batch
View Details
Data Analytics Courses 2021-12-11 2021-12-12
(Sat-Sun) Weekend batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *

Looking for 50% Salary Hike ?

Speak to our course Advisor Now !

Associated Courses

Subscribe to our newsletter

Signup for our weekly newsletter to get the latest news, updates and amazing offers delivered directly in your inbox.