A method for transforming paths in a logical model to their physical equivalent in a physical model is provided. A logical model is retrieved. All entities in the logical model are mapped. All paths connecting the entities of the logical model are mapped. Tables are created that correspond to the entities in the logical model for traceability. Columns are created that correspond to attributes of the paths in the logical model for traceability. A reduced logical model is created by reducing overlapping paths in the logical model. Virtual logic paths are created where an entity is rolled up, is rolled down, or participates in a many-to-many relationship in the reduced logical model. The reduced logical model is transformed into a physical model.