Logical and Physical Data Modeling
The logical data modeling portion of this seminar teaches the disciplines necessary to form, define, and standardize data elements so that they can be shared for all business purposes, instead of being tailored to fit only one use or point of view (as was common in "systemland"). The principles of normalization are taught in a natural and practical manner to ensure that the organization of the data is also optimal for all uses.
The physical data modeling portion of the seminar teaches a very sophisticated method for quantifying the physical constraints imposed by the business (performance of certain transactions, data volume limitations, physical distribution of the data at different locations, security protection of selected data, etc.), and for creating a best-balanced physical design of the database which meets those (sometimes conflicting) constraints without sacrificing the natural subject organization of the data.

Extensive workshops in both logical and physical data modeling ensure that the student leaves this seminar with internalized, usable and practical skills.

Seminar Objectives

This seminar begins where Conceptual Data Modeling: The Entity/Relationship Model ends, completing the set of skills necessary to move from the gross analysis of business information requirements to the actual physical implementation of sharable, subject-oriented databases which will markedly improve business performance and profitability. Who should attend? IS/IRM Management Data Administrators/Data Base Administrators Conceptual/Logical Data Modelers Physical Database Designers Process/Transaction Modelers Development Project Managers End users participating in development projects PREREQUISITE: It is highly recommended that the student attend the Conceptual Data Modeling: Entity/Relationship Model seminar, or that they have a good grasp of conceptual/ER modeling fundamentals and practice.