A normalized Logical Data Model eliminates redundancies in data storage and capture. The normalized Logical Data Model serves as the basis for the Physical Data Model. The Physical Data Model is a graphical representation of the physical database to be implemented. Indexes are often defined for performance gain. Part of this role is to organize information exchange, such as brainstorming sessions, with the users.
Users ultimately provide all the data needed to build the model.
Since several activities are involved in the development of the Logical Data Model, the methodology divides its development into three distinct parts. Data elements are fully attributed. At a minimum, all primary keys and most foreign keys are access points. Non-key fields can also be access points. Use optionality to determine whether the foreign key is nullable.