Task: Detail Logical Data Model
Further refine and develop the logical data design of the database based on the business requirements for the solution.
Purpose

Progress toward a stable yet extensible model of the data design that serves as an input to development of the physical database design


Relationships
RolesPrimary: Additional: Assisting:
InputsMandatory: Optional:
  • None
External:
  • None
Outputs
Main Description
  • Fully identify entities, relationships, and attributes for each entity needed to support the requirements
  • Detail each entity's attributes and keys
  • Normalize the data
  • Take into account for both static and dynamic data behaviors
Properties
Multiple Occurrences
Event Driven
Ongoing
Optional
Planned
Repeatable
Key Considerations
  • Data design and application logic design are highly dependent on and related to one another. Achieving good data design requires strong, ongoing teaming with application logic designers throughout the development cycle.
  • Physical implementation considerations are not factored in to logical database design. Independence from these concerns enables flexible yet stable data designs.
More Information