[Company Logo Image]       



There are three levels of data modeling. They are conceptual, logical, and physical. The following will explain the difference among the three, the order with which each one is created, and how to go from one level to the other.

Conceptual Data Model

Features of conceptual data model include:

bulletIncludes the important entities and the relationships among them.
bulletNo attribute is specified.
bulletNo primary key is specified.

At this level, the data modeler attempts to identify the highest-level relationships among the different entities.

Logical Data Model

Features of logical data model include:

bulletIncludes all entities and relationships among them.
bulletAll attributes for each entity are specified.
bulletThe primary key for each entity specified.
bulletForeign keys (keys identifying the relationship between different entities) are specified.
bulletNormalization occurs at this level.

At this level, the data modeler attempts to describe the data in as much detail as possible, without regard to how they will be physically implemented in the database.

In data warehousing, it is common for the conceptual data model and the logical data model to be combined into a single step (deliverable).

The steps for designing the logical data model are as follows:

  1. Identify all entities.
  2. Specify primary keys for all entities.
  3. Find the relationships between different entities.
  4. Find all attributes for each entity.
  5. Resolve many-to-many relationships.
  6. Normalization.

Physical Data Model

Features of physical data model include:

bulletSpecification all tables and columns.
bulletForeign keys are used to identify relationships between tables.
bulletDe-normalization may occur based on user requirements.
bulletPhysical considerations may cause the physical data model to be quite different from the logical data model.

At this level, the data modeler will specify how the logical data model will be realized in the database schema.

The steps for physical data model design are as follows:

  1. Convert entities into tables.
  2. Convert relationships into foreign keys.
  3. Convert attributes into columns.
  4. Modify the physical data model based on physical constraints / requirements.

Information Request Form

Select the items that apply, and then let us know how to contact you.

Send service literature
Send company literature
Have a salesperson contact me



Feedback/contact us          Terms and Conditions.             Privacy Policy      Glossary of Terms    search the web

Send mail to webmaster@atksi.com with questions or comments about this web site.
Copyright 2002 Advanced TurnKey Solutions, LLC
 All rights reserved.