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.
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: 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.2 Scope, Approach and Methods
1.3 System Overview
1.4 Acronyms and Abbreviations
1.5 Points of Contact
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.2.1 Hardware Architecture
2.2.2 Software Architecture
3 Database Design Decisions
4 Database Administrative Functions
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.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.11 Performance Improvement
4.12 Functional Support
4.13 Historical Data
4.14 Business Rules
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.1 Reporting Requirements
6.2 Design issues
7 Data Access
7.1 Role Definitions
7.3 Table Access Patterns
8 Implementation Considerations
8.1 Large Objects
9 Non-Functional Design
9.1 Security Design
9.5 Error Processing
9.6 Backups and Recovery
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|
|Data Model||1 Spreadsheet|
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 File, Save 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
- How does the order process work?
- How can I Pay with my Credit Card (instead of PayPal)?
- What’s the license agreement?
Who are your Customers?
Here is a sample list of our customers.
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 klariti.com or info at klariti.com or ivanawalsh at gmail.com. 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?
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.
How Can I Contact You?
You can contact me at:
- Email: ivan at klariti.com / info at klariti.com / ivanawalsh at gmail.com
- 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.