Transcript Lecture 9 – Database Design

Lecture 9 – Database Design
Systems Development Life Cycle
(SDLC)
Database Life Cycle
(DBLC)
Lecture Objectives
• Define Information System, System
Analysis, System Development, and
Database Development
• Discuss the components of the Systems
Development Life Cycle
• Discuss the components of the Database
Life Cycle
Definitions – Information Systems
• Allows for data collection, storage, and retrieval
• Facilitates the transformation of data into
information and the management of data and
information
People + Hardware + Software + Databases +
Application Programs + Procedures
=
INFORMATION SYSTEM
Definitions – Systems Analysis
• Process that establishes the need and the extent
for information systems
• Analyzing in detail the information needs of an
organization, the characteristics and
components of presently utilized information
systems, and the functional requirements of
proposed information systems.
Definitions – Systems Development
• Process of creating the information system
• Use the results of the systems analysis to
determine the requirements and hence
use the requirements to develop the
information system
– Databases, application software, etc.
Definitions – Database Development
• Process of database design and
development
• Database Design
– Complete, normalized, non-redundant and
fully integrated conceptual, logical, and
physical database models
• Database Implementation
– Database storage structure, loading data, and
data management
Systems Development Life Cycle
(SDLC)
Planning
•Traces the history of
an information system
Analysis
•Split into 5 phases
Detailed System Design
Implementation
Maintenance
•Database design an
essential component of
the SDLC
Systems Development Life Cycle
(SDLC)
Planning
Analysis
Detailed System Design
Implementation
Maintenance
• Initial Assessment
• Feasibility Study
• Should the existing
system be:
i) Continued?
ii) Modified?
iii)Replaced?
• System Cost
• Technology
Systems Development Life Cycle
(SDLC)
Planning
Analysis
Detailed System Design
Implementation
Maintenance
• User Requirements
• Existing System
Evaluation
• Logical System
Design
Systems Development Life Cycle
(SDLC)
Planning
Analysis
Detailed System Design
Implementation
Maintenance
• Detailed
Specifications
• Screen, menu,
report layouts
• Conversion from old
to new
Systems Development Life Cycle
(SDLC)
Planning
• Coding
Analysis
• Testing
Detailed System Design
• Debugging
Implementation
Maintenance
• Installation
Systems Development Life Cycle
(SDLC)
Planning
Analysis
Detailed System Design
• Evaluation
• Maintenance
• System Errors
• Business
Changes
Implementation
• Enhancements
Maintenance
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
Testing and Evaluation
Operation
Maintenance and Evaluation
• Traces the history of
the creation of a
database
• Split into 6 phases
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
• Analyze company
situation
• Define Problem and
Constraints
Testing and Evaluation
• Define Objectives
Operation
• Define Scope and
Boundaries
Maintenance and Evaluation
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
Testing and Evaluation
Operation
Maintenance and Evaluation
• Conceptual Design
• ER-Diagram /
Normalization
• DBMS Software
Selection
• Create the Logical
Design
• Create the Physical
Design
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
• Install the selected
DBMS
• Create the
databases
Testing and Evaluation
Operation
Maintenance and Evaluation
• Load the data /
Convert from Old
System
Database Life Cycle (DBLC)
Database Initial Study
• Test the Database
Database Design
Implementation and Loading
Testing and Evaluation
Operation
Maintenance and Evaluation
• Fine-Tune the
Database
• Evaluate the
Database and its
Application
Programs
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
Testing and Evaluation
Operation
Maintenance and Evaluation
• Produce the required
information flow
• Alternate form of
testing
Database Life Cycle (DBLC)
Database Initial Study
Database Design
Implementation and Loading
Testing and Evaluation
Operation
Maintenance and Evaluation
• Changes to the
System (from
operation, bugs,
business changes)
• Enhancements
Life Cycle Effectiveness
DOCUMENTATION