Estimation Considerations: Physical Database Design for a transaction based system
These considerations help determine an estimate for the effort required to produce a Physical Database Design as a percentage of time for the earlier design artifacts.
Relationships
Main Description

One or more of the following can be used as input to the estimation:

  • The number of persistent classes in the class diagram, and the relationships
  • The number of entities in the logical data model, and the relationships
  • Also consider adding time for the following factors 
    • Spread of data across platforms
    • Volumetric considerations
    • Performance considerations


The time taken will vary depending on the use of a database modeling tool. Use of a tool for completing this artifact will save time in the areas of performing space calculations and writing DDL. The range can vary between:

  • 20%-30% of time taken for the class diagram and/ or logical data model if using a database design tool
  • 33% - 50% of time taken for the class diagram and/ or logical data model if not using a database design tool