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


data model

A description of the organization of a database. It is often created as an entity relationship diagram. Today's modeling tools allow the attributes and tables (fields and records) to be graphically created. The SQL code that defines the data structure (schema) in the database is automatically created from the visual representation. See entity relationship model.




Building an Entity Relationship Model
The Erwin modeling program from Logic Works, Princeton, NJ, 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 Logic Works, Inc.)






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
data manipulationdata modem
data manipulation languagedata module
data marshalingdata mover
data marshallingdata name
data martdata network
Data Matrixdata normalization
data migrationdata overload
data minerdata packet
data miningdata parallel
data mirroringdata path

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