Alan Freedman -- The Computer Language Company - Computer Desktop Encyclopedia
Computer Desktop Encyclopedia
Longest-Running Tech Reference on the Planet

A CDE Definition

You'll love The Computer Desktop Encyclopedia (CDE) for Tech Term of the Day (TTOD)

LOOK UP ANOTHER TERM


Erwin

(Entity Relationship for WINdows) A data modeling program for Windows from CA Technologies. It allows the database schemas to be built graphically and turns the graphs into the appropriate SQL code for creating PowerBuilder, DB2, Oracle, Sybase and other databases. Erwin was originally developed by Princeton, New Jersey-based LogicWorks, which was acquired by Platinum Technology and then Computer Associates (CA Technologies). See entity relationship model.



entity relationship model

A database model that describes the attributes of entities and the relationships among them. An entity is a file (table). Today, ER models are often created graphically, and software converts the graphical representations of the tables into the SQL code required to create the data structures in the database. See data model and dimensional modeling.




Building an Entity Relationship Model
The Erwin modeling program from CA Technologies stands for Entity Relationship for Windows. In this order processing example, the tables for customers and orders are drawn graphically, and Erwin turns the graph into the appropriate SQL code for the target database. (Example courtesy of CA Technologies, Inc.)






Personal Use Only

Before/After Your Search Term
BeforeAfter
ERPeRx
Error 53ES
error checkingES/3090
error controlES/9000
error correctionESA
error detection & correctionESA/370
error-free channelESA/390
error handlingeSATA
error messageseSATA Hybrid Port
error rateeSATA interface

Terms By Topic
Click any of the following categories for a list of fundamental terms.
Computer Words You Gotta KnowSystem design
Job categoriesUnix/Linux
Interesting stuffPersonal computers
InternetIndustrial Automation/Process Control
Communications & networkingAssociations/Standards organizations
HistoryDesktop publishing
Audio/VideoGraphics
MainframesSecurity
ProgrammingHealthcare IT
System design