Lesson 3: Database Development Process
The resources that enable the collection, management, control and dissemination of
information throughout an organization.
Information System
COMPONENTS OF A COMPUTER-BASED INFORMATION SYSTEM
database
database software
application software
computer hardware including storage media
personnel using & devoloping the system
DATABASE LIFE APPLICATION CYCLE:
This involves planning how the stages of the lifecycle can be realized most effectively as
possible
Database Planning
3 MAIN COMPONENTS OF DATABASE PLANNING
The work to be done
The resources with w/c we do it
The money to pay for it all
DATABASE LIFE APPLICATION CYCLE:
The scope & boundaries of the database application including its major application & areas &
user groups.
System Definition
DATABASE LIFE APPLICATION CYCLE:
This involves the collection & analysis of the requirements of users & application areas
Requirement Collection & Analysis
DATABASE LIFE APPLICATION CYCLE:
Includes conceptual, logical, and physical design of your database
Database Design
DATABASE LIFE APPLICATION CYCLE:
The selection of an appropriate DBMS to support the Information System
DBMS Selection
DATABASE LIFE APPLICATION CYCLE:
The design of software programs that will use & process the database
Application Design
DATABASE LIFE APPLICATION CYCLE:
Building a working model of the database application system which allows the designer or
user to test the system
Prototyping
DATABASE LIFE APPLICATION CYCLE:
Physical realization of the database & application design. Involves creating the conceptual,
external & internal database definition & the application programs
Implementation
DATA LIFE APPLICATION CYCLE:
Transferring any existing data into the new database converting & existing applications to
run on your database
Data Conversation & Loading
DATABASE LIFE APPLICATION CYCLE:
The process of executing the application programs of finding errors.
Testing
DIFFERENT TESTING STRATEGIES INCLUDES:
First end-to-end testing of a product/system to ensure it meets the requirements and functions correctly.
Alpha Testing
DIFFERENT TESTING STRATEGIES INCLUDES:
The final round of testing before the product/system is finally release to wide audience/users
Beta Testing
DIFFERENT TESTING STRATEGIES INCLUDES:
A software testing that verify the stability and reliability of a software application
Stress Testing
DIFFERENT TESTING STRATEGIES INCLUDES:
A software testing in which the individual's software modulesare combined and tested as a group
Integration Testing
DIFFERENT TESTING STRATEGIES INCLUDES:
A software testing where the individual unit or the components of software are tested
Unit Testing
DATABASE LIFE APPLICATION CYCLE:
The process of monitoring and maintaining the system following installation
Operational Maintenance