This figure illustrates differences between logical design and physical design. The logical entities are:

• entities

• relationships

• attributes

• unique identifiers

The logical model is mapped to the following database structures:

• tables

• indexes

• columns

• dimensions

• materialized views

• integrity constraints