Skip to main content

MSF for CMMI Process Improvement

Go Search
Home
  
MSF for CMMI Process Improvement > Wiki Pages > Activity - Review Database Code  

Activity - Review Database Code

Activity Information

Review Database Code

Description

A code review is used to identify areas that might cause problems for future development and testing. Code reviews also provide additional insight from other developers on how code should be written. With reviewed code, others working in the same area can follow the precedents set by previous developers. Buddy reviews require a single, knowledgeable peer to go through the changes with the developer before checking in the code.

Roles

ResponsibleDatabase Developer

Attributes

Element Categories[CMMI Cycle 4] Iteration, [CMMI Level 3] PI SP 3.1, [CMMI Track 3] Build, [CMMI Level 3] VER SP 2.1, [CMMI Level 3] VER SP 2.2
Entry Criteria
Database Unit Tests Complete:
Database unit tests are complete and the code is debugged.
Exit Criteria
Database Code Reviewed:
The database code is reviewed, fixed, deployed to the local server, and unit tested.
Is RequiredYes

Steps

  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.

Inputs and Outputs

WorkProductInputOutputAllowable States
Review(none)

Predecessors

TypeNameDependency Type
Refactor Database CodeFinish-Start

Successors

TypeNameDependency Type
Integrate Database Code ChangesFinish-Start

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