Physical: It is a database-specific model that comprises columns, relational tables, and their associated data types.This model type is principally at the ER modeling level. Logical: It is a theoretical model that contains entities, attributes, and relationships.There are three model types supported by ERwin which is used by a Database Developer: 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.
The middle portion of the workspace consists of two panes: the model explorer panel and the diagram window. The upper portion of the workspace consists of Menu and Toolbars. ERwin supports a pattern of features of database strategy, which includes modeling the 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.
0 kommentar(er)
