Skip to main content

Enterprise MSF Agile (with CobiT)

Go Search
Home
  
Enterprise MSF Agile (with CobiT) > Wiki Pages > Activity - Review Database Code (Create a Quality of Service Requirement)  

Activity - Review Database Code (Create a Quality of Service Requirement)

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

PerformerDatabase Developer

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
Code(none)

Predecessors

TypeNameDependency Type
Refactor Database CodeFinish-Start

Successors

TypeNameDependency Type
Integrate Database Code ChangesFinish-Start

Last modified at 1/17/2008 11:18 PM  by Administrator