The Database Design Document maps the logical data model to the target database management system with consideration to the system's performance requirements. The Database Design converts logical or conceptual data constructs to physical storage constructs (e.g., tables, files) of the target Database Management System (DBMS).

The Database Design Document contains the following topics:

  Document objectives
  Intended audience
  Key personnel
  Data owners
  Assumptions, constraints and dependencies
  System Overview
        Database management system configuration
        Database software utilities
        Support software
  Architecture
        Hardware architecture
        Software architecture
        Datastores
  Database-Wide design decisions
        Interfaces
        Key factors influencing design
        Behavior
        DBMS platform
        Security and availability
        Distribution
        Backup and restore operations
        Maintenance
  Database administrative functions
        Responsibilities
        Database identification
        Applications / systems using the database
        Relationships to other databases
        Schema information
        Physical design
        Physical structure
        Entity mapping
        Mapping rules
        Operational implications
        Data transfer requirements
        Data formats
        Business rules
        Storage
        Backup and recovery
  Detailed database design
      Data software objects and resultant data structures
      Database management system files
  Reporting requirements.

Scroll down to the IT Database Design Document example below.