Database Specification

The fourth step in the DDLC is specifying a physical database from the logical data model. The database specification will choose the appropriate database implementation structure by determining the purpose of the database and the DBMS that will be used to implement the database. The output of the database design process is the database creation DDL script and reports documenting the database.

1	Background
1.1	Database Types
1.2	Data Governance Requirements
1.3	Logical Data Type Implementation
1.4	Table Keys, Alternate Keys and Indexes
1.5	Database Naming Convention
2	DDLC Process
2.1	Database Specification Process
3	DDLC Deliverables
3.1	Database DDL
3.2	Physical Database Diagram
3.3	Database Table List
3.4	Database Column List
3.5	Database Interface List
4	SDLC Deliverables
4.1	Functional Specification
5	DDLC/SDLC Interface Deliverables
5.1	Database Interface Specification