Transcript Systems Development Life Cycle

The Database Development
Process
Muhammad Nasir
[email protected]
Outline






Software Development Life Cycle
Planning
Analysis
Design
Implementation
Maintenance
Database Development Process

Conceptual schema
A detailed, technology independent
specification of the overall structure of
organizational data

Logical schema
The representation of a database for a
particular data management technology
Database Development Process

Physical schema
Specifications for how data from a logical
schema are stored in a computer’s
secondary memory by a database
management system.
Database Development Process

Project
A planned undertaking of related activities to
reach an objective that has a beginning
and an end.
The Database Development Process

Systems Development Life Cycle (SDLC)
The traditional methodology used
to develop, maintain, and replace
information systems
Systems Development Life Cycle





Planning
Analysis
Design
Implementation
Maintenance
Systems Development Life Cycle
Planning
Enterprise Modeling
 Analyze current data processing
 Analyze the general business
functions and their database needs
 Justify need for new data and
databases in support of business
Planning
Conceptual Data Modeling
 Identify scope of database
requirements for proposed information
system
 Identify only high-level categories of
data (entities) and major relationships
Planning

Purpose: To develop a preliminary
understanding of a business situation
and how information systems might
help solve a problem or make an
opportunity possible
Analysis
Conceptual Data Modeling, Cont’d.
 Develop preliminary conceptual data model,
including entities and relationships
 Develop detailed conceptual data model,
including all entities, relationships,
attributes, and business rules
 The output of the conceptual modeling
phase is a Conceptual Schema (ERD).
Analysis

Purpose: To analyze the business
situation thoroughly to determine
requirements, to structure those
requirements, and to select among
competing system features
Design
Logical database design
 Analyze in detail the transactions, forms,
displays, and inquiries (database views)
required by the business functions
supported by the database
 Integrate database views into conceptual
data model
 Identify data integrity and security
requirements, and populate repository
Design
Physical database design and definition
 Define database to DBMS (often
generated from repository)
 Design database processing programs
Design

Purpose: To elicit and structure all
information requirements; to develop
all technology and organizational
specifications
Implementation
Database implementation
 Code and test database processing
programs
 Complete database documentation
and training materials
 Install database and convert data from
prior systems
Implementation

Purpose: To write programs, build
databases, test and install the new
system, train users, and finalize
documentation
Maintenance
Database Maintenance
 Analyze database and database
applications to ensure that evolving
information requirements are met
 Tune database for improved
performance
 Fix errors in database and database
applications and recover database
when it is crashed or damaged
Maintenance

Purpose: To monitor the operation
and usefulness of the system, and to
repair and enhance the system
The End


Thanks for listening
Questions would be appreciated.