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)