MSF for Agile Software Development Visual Studio 2005 Team System logo

Activity:

Review Database Code

Participating Roles

Responsible:

Database Developer

Overview

Entry Criteria

  • Database unit tests are complete and the code is debugged.

Sub-Activities

1

Verify Name Correctness

  • Make sure the names of the schema objects are properly defined to represent the functionality of the code segment.

2

Verify Code Relevance

  • The code being reviewed is relevant to the task for which the code is written. There should be no code changes allowed that do not address the functionality to be implemented or corrected.

3

Verify Minimum Code Complexity

  • Repeated code can be simplified into common functions.

4

Fix Review Changes

  • Fix any changes that came out of the review.

5

Build Database Project

  • Build the database project.
  • Review and fix any build errors identified.

6

Deploy Database Project to Sandbox Server

  • Deploy database project to sandbox server.
  • Ensure deployment is successful by browsing deployed database.

7

Perform Database Unit Tests

  • Perform unit tests to ensure no regressions were introduced.
  • Fix any nonworking unit tests.

Exit Criteria

The database code is reviewed, fixed, deployed to the local server, and unit tested.

© 2006 Microsoft Corporation. All rights reserved.

Version 4.1.0