Previous Topic: Using the Data Structure ListNext Topic: One-to-Many Relationships

Designing the Data Structure › Using the Data Structure List › Data Structure Terminology

Data Structure Terminology

The equivalent data modeling, relational, and production terms are shown in the following table.

Data Structure Terms

CA Gen Model

Relational Term

Production

Data Model

Data structure (physical design)

Database implementation by the DBMS

Entity Type and its Subtypes

One Table

Table

Attribute - Basic

Column

Column

Attribute - Designed

Column

Column

Attribute - Derived

Not implemented physically

Not implemented physically

Attribute - Auto Number

Column

Column

Relationship (1:1 or 1:M)

Foreign key

RI constraint

Relationship (M:N)

Table

Table

Identifier

Index

Index (unique)

N/A (added to the Data Structure List)

Denormalized column

Column

N/A (added to the Data Structure List)

Index

Index (typically non-unique)