Stage 1 : Define Scope of the Database Project
- Identify which organizational subdivisions will be served by the database
- Define which functions within these organizations will utilize the
database
- Identify which existing and planned applications will be converted to the
database system
- Prepare proposal for management and obtain go-ahead
rules of the internet
Stage 2 : Organize Database Project
- Pick users for design team
- Select database Administrator (DBA)
- Establish regular meetings and periodic management reporting for design
team
Stage 3 : Select Database Management System Products
- Document requirements in formal proposal requests
- Select DBMS vendor
Stage 4 : Develop Initial Implementation Plan and Schedule
- Identify files that will be converted
- Identify programs within applications specified
- Estimate programmer hours needed to modify applications programs
- Estimate user clerical support needed to verify data using conversion
- Develop implementation schedule
Stage 5 : Design Database
- Complete detailed information requirements
- Identify data requirements
- Determine data structure and complete design
specifications
- Review and approve design specifications
Stage 6 : Perform Training
- Develop training requirements and training
schedule
- Train programmers in the use of DML (Data
Manipulation Language)
- Train DBA in DMCL (Data Manipulation Control
Language) and DDL (Data Definition Language)
Stage 7 : Install and Test
Database
- Code DMCL, schema and subschema
- Modify representative programs for DBMS test
- Code conversion programs
- Generate the database
- Test and debug
- Review and approve test results
Stage 8 : Develop
Detailed Conversion Plan
- Make individual programming assignments for
each program to be modified and each file to be loaded
- Schedule users to verify and correct file
contents
- Schedule computer availability
- Prepare formal written conversion schedule and
obtain commitments and from all parties involved
- Approve conversion involved
Stage 9 : Convert Existing
Applications
- Bring up one application at a time
- Update and regenerate database as required
- Approve revised applications as they are
converted
- Begin using database for new applications and
programs
Stage 10 : Fine-Tune
Database
- Monitor DBMS access statistics and visible
performance, and modify database as required
- Regenerate database when necessary
Stage 11 : Periodically
Review Database Performance
- Restate organizational goals and information
requirements
- Evaluate success of database project
- Begin new database projects when required
|