Skip to main content

MSF for CMMI Process Improvement

Go Search
Home
  
MSF for CMMI Process Improvement > Wiki Pages > Activity - Write Code for a Database Development Task  

Activity - Write Code for a Database Development Task

Activity Information

Write Code for a Database Development Task

Description

The next step is to actually write the code associated with the database development task at hand. This may involve updating existing database schema objects or creating new ones. After each set of changes is made, the changes should be iteratively deployed to the sandbox server for testing.

Roles

ResponsibleDatabase Developer

Attributes

Element Categories[CMMI Cycle 1] Check In, [CMMI Track 3] Build, [CMMI Level 3] TS SP 3.1
Entry Criteria
Task Reviewed:
The database development taskĀ is reviewed. The developer understands the scope and requirements of the task.
Exit Criteria
Code for database development task is complete:
The code for the database development task is complete.
Is RequiredYes

Steps

  1. Implement New or Update Existing Schema Objects:

    Add new schema objects if necessary.

    Implement new schema objects.

    Check out existing objects that need to be changed.

    Update existing schema objects if necessary.
  2. Build Database Project:

    Build the database project.

    Review and fix any build errors identified.
  3. Deploy Database Project to Sandbox Server:

    Deploy database project to sandbox server.

    Ensure deployment is successful by browsing deployed database.

Predecessors

TypeNameDependency Type
Update Local Project EnvironmentFinish-Start

Successors

TypeNameDependency Type
Perform a Database Unit TestFinish-Start

Last modified at 12/19/2007 10:37 AM  by Administrator