banner image for William G. Smith & Associates

LOGICAL AND PHYSICAL DATA MODELING

This popular skill-building seminar begins where Conceptual Data Modeling: The Entity/Relationship Model ends, completing the student's skills in the three-phase process of Conceptual, then Logical, then Physical Data Modeling to build properly organized, shared, stable, well-defined, easy to use, and easily maintained databases which will markedly improve business performance and profitability. The three-step Conceptual, Logical and Physical Data Modeling process ensures that each particular concern is addressed in its proper time and sequence to completely eliminate error and rework. This is not only the fastest way to design databases, it is also the cheapest and the best -- a threefer!

The Logical Data Modeling (LDM) portion of this seminar teaches step-by-step techniques, skills, and rules necessary to form, define, standardize, and normalize the data elements (individual data facts) into the entities (conceived and defined in Conceptual Data Modeling) so that they can be shared for all business purposes. The principles of data normalization (first, second and third normal form) are taught in a natural and practical manner to ensure that the student can properly organize data in the LDM so it is non-redundant, easy to find, and sharable for all uses.

The Physical Data Modeling portion of the seminar teaches a very sophisticated step-by-step method for qualifying (and if possible, quantifying) the physical constraints imposed by the business (performance speeds of 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 acquires usable and practical skills.

The seminar material is completely independent of any vendor's CASE tool or database management system (DBMS).

TOPICAL OUTLINE


DURATION: 5 days

TARGETED AUDIENCES: (recommended maximum number of attendees - 25)

PREREQUISITE: Conceptual Data Modeling: the Entity/Relationship Model


RETURN TO SEMINARS PAGE

RETURN TO TOP OF PAGE

© 2013 WILLIAM G. SMITH