Database Design Document (MS Word Template + MS Excel Data Model)

You can use this Database Design Document template to map the logical data model to the target database management system with consideration to the system’s performance requirements. Use this template to:

  • Define the basis for the application’s database design.
  • Provide expected data volumes, functional/non-functional usage of tables.
  • Ensure database transactions meets or exceed performance requirements.

Download Now for only $9.99

Download Template

Database Design Document Template: Red MS Blue Theme

Database Design Document Template: Red MS Word Theme

This Database Design Document (DDD) converts logical data constructs to the tables and files of the target DBMS.

Database Design Document Template

Database Design Document Template

Database Design Document Template

Database Design Document Template

Database Design Document Template

Download Now for only $9.99

Download Template

Database Design Document: Free Data Model Template

This Database Design Document template includes a free Data Model spreadsheet which you can modify for your next project. It comes with sample data to help you get started.

Data Model template in MS Excel

Database Design Document Template: Table of Contents

This Database Design Document template includes the following chapters, sections and sample text.

1 Introduction
1.1 Purpose
1.2 Scope, Approach and Methods
1.3 System Overview
1.4 Acronyms and Abbreviations
1.5 Points of Contact
1.5.1 Information
1.5.2 Coordination
1.5.3 Data Owners

2 System Overview
2.1 System Information
2.1.1 Database Management System Configuration
2.1.2 Database Software Utilities
2.1.3 Support Software
2.1.4 Security
2.2 Architecture
2.2.1 Hardware Architecture
2.2.2 Software Architecture
2.2.3 Interfaces
2.2.4 Datastores

3 Database Design Decisions
3.1 Assumptions
3.2 Issues
3.3 Constraints

4 Database Administrative Functions
4.1 Responsibility
4.2 Naming Conventions
4.3 Database Identification
4.4 Systems Using the Database
4.5 Relationship to Other Databases
4.6 Schema Information
4.6.1 Description
4.6.2 Physical Design
4.6.3 Physical Structure
4.7 Special Instructions
4.8 Standards Deviations
4.9 Entity Mapping
4.9.1 Mapping rules
4.9.2 Entities and Attributes Not Implemented
4.9.3 Non-trivial Mapping
4.9.4 Additional Objects
4.9.5 Key mappings
4.9.6 Other Deviations
4.10 Denormalisation
4.11 Performance Improvement
4.12 Functional Support
4.13 Historical Data
4.14 Business Rules
4.15 Storage
4.16 Recovery

5 Database Interfaces
5.1 Database Interfaces
5.1.1 Operational Implications
5.1.2 Data Transfer Requirements
5.1.3 Data Formats
5.2 Interface [Name] 5.3 Dependencies

6 Reporting
6.1 Reporting Requirements
6.2 Design issues
7 Data Access
7.1 Role Definitions
7.2 Users
7.3 Table Access Patterns

8 Implementation Considerations
8.1 Large Objects
8.2 Queues
8.3 Partitioning

9 Non-Functional Design
9.1 Security Design
9.2 Availability
9.3 Scalability
9.4 Performance
9.5 Error Processing
9.6 Backups and Recovery
9.7 Archiving

Database Design Document Template: Format & Content

The templates in this Database Design Document are in Microsoft Word and Excel format (.doc & .xls).

The template pack includes the following documents:

2 x Database Design Document templates 26 pages each Download Word template
Data Model 1 Spreadsheet

Download Now for only $9.99

Download Template

Product Specifications

File Format: The templates are in Microsoft Word  (.docx) and Microsoft Excel (.xlsx) format.

Opening the Files: You don’t need any special software to unzip the files. To unzip the files, right click on it, then select Extract, and save it to your computer.

Getting Started: Depending on your MS Office settings, the files may say Read Only when you open them. If this occurs, click FileSave As and save the files. There are no security settings on any of the files.

Images: All of the images in the templates are copyright free.

 60-day Money-Back Guarantee

 Secure Online Order Form


Who are your Customers?

Here is a sample list of our customers.

Technical Support

I am here to help you with any questions. You can contact me directly if you need any helping using these templates.

What file formats do the templates work in?

The files work in MS Word 97, 2003, 2007, Office 2010, Office 2016, Windows 7, XP, Vista, and Apple iWork (if you have Word for Mac), and Google Docs.

How do I get my templates?

After you make the payment, you are sent an email. This has a link to a Download Page from where you can save the templates,

Where are my templates?

By default, when you download the files, they are saved to the Download folder on your computer.

What is the refund policy?

We offer a 60 days refund policy.

I have not received my product. Who do I contact?

Please email ivan at or info at or ivanawalsh at Please include your order number.

Help! I’ve accidentally deleted my templates!

Just drop us a line with the order number. We’ll send it out.

Why does my file say it’s corrupt?

If you open a zip file during the download, it may display an error message that the file is corrupt. What this means is that not all of the file have downloaded and therefore the system thinks its contents are corrupt. Please try to download the file again or contact us for assistance. Email us the receipt number you received from eJunkie and we’ll send you another copy.

How Do I Buy the Templates?

This page explains the order process.

It shows how to order templates, how can you pay (with PayPal or with Credit Cards), and how to download the template.

How do I Download the Templates?

After you buy the order, you’ll get an email with a link to download the templates.

If you have any problem downloading the templates, send me the order number and I will get back to you.

Please allow 12 hours for a response as our time zone may be different than yours.

How do I Pay with my Credit Card (Instead of PayPal)

This page explains how to buy templates using your credit card instead of PayPal.

Note: You do NOT need a PayPal account to place an order. You can pay for your order using your credit or debit card.

Read How to Pay with Your Credit Card (Instead of PayPal) here.

How Can I Contact You?

You can contact me at:

  • Email: ivan at / info at / ivanawalsh at
  • Tel: 00.353.860.886.349
  • Facebook / Twitter

As we’re in Europe, there may be a time difference when getting back to you.

Again, if there are any problems, just let me know.


Ivan Walsh

Related Products

Software Development Templates – MS Office – Apple iWorks

Software Testing Templates – MS Office – Apple iWorks