Login or Sign Up to become a member! LessThanDot Site Logo   A
Technical Community for IT Professionals   Browsing "whiteboard"
Why (and How) I Model    Creating a Conceptual Data Model  There
are three types of data models: Conceptual, Logical, and
Physical. The conceptual model provides a high-level view of the
data, defining the general entities and entity relationships
using the language of the business or organization. The logical
model adds attributes to these entities, providing a technology-
agnostic foundation for a database design. The physical model
assigns table names, column names, and data types to the
entities and attributes defined in the prior models. Defining
the data model in distinct layers helps us manage the complexity
of design and focus as we refine our understanding of the
problem space.