Chapter 2:
The Database Development
Process
Modern Database Management
8th Edition
Jeffrey A. Hoffer, Mary B. Prescott,
Fred R. McFadden
© 2007 by Prentice Hall 1
Objectives
Definition of terms
Describe system development life cycle
Explain prototyping approach
Explain three-tiered architectures
Explain scope of database design projects
Chapter 2 © 2007 by Prentice Hall 2
Two Approaches to Database
and IS Development
SDLC
System Development Life Cycle
Detailed, well-planned development process
Time-consuming, but comprehensive
Long development cycle
Prototyping
Rapid application development (RAD)
Cursory attempt at conceptual data modeling
Define database during development of initial
prototype
Repeat implementation and maintenance activities
with new prototype versions
Chapter 2 © 2007 by Prentice Hall 3
Systems Development Life Cycle
(see also Figures 2.4, 2.5)
Planning
Analysis
Logical Design
Physical Design
Implementation
Maintenance
Chapter 2 © 2007 by Prentice Hall 4
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Planning
Planning Purpose–preliminary understanding
Deliverable–request for study
Analysis
Logical Design
Physical Design
Database activity– Implementation
enterprise modeling
and early conceptual
Maintenance
data modeling
Chapter 2 © 2007 by Prentice Hall 5
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Purpose–thorough requirements analysis
Planning and structuring
Deliverable–functional system specifications
Analysis
Analysis
Logical Design
Physical Design
Database activity–Thorough Implementation
and integrated conceptual
data modeling
Maintenance
Chapter 2 © 2007 by Prentice Hall 6
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Purpose–information requirements elicitation
Planning and structure
Deliverable–detailed design specifications
Analysis
Logical Design
Logical Design
Physical Design
Database activity– Implementation
logical database design
(transactions, forms,
Maintenance
displays, views, data
integrity and security)
Chapter 2 © 2007 by Prentice Hall 7
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Purpose–develop technology and
Planning organizational specifications
Deliverable–program/data
Analysis structures, technology purchases,
organization redesigns
Logical Design
Physical Design
Physical Design
Database activity– Implementation
physical database design
(define database to DBMS,
Maintenance
physical data organization,
database processing programs)
Chapter 2 © 2007 by Prentice Hall 8
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Purpose–programming, testing, training,
Planning installation, documenting
Deliverable–operational programs,
Analysis documentation, training materials
Logical Design
Physical Design
Database activity–
database implementation, Implementation
Implementation
including coded programs,
documentation, Maintenance
installation and conversion
Chapter 2 © 2007 by Prentice Hall 9
Systems Development Life Cycle
(see also Figures 2.4, 2.5) (cont.)
Planning Purpose–monitor, repair, enhance
Deliverable–periodic audits
Analysis
Logical Design
Physical Design
Database activity–
database maintenance, Implementation
performance analysis
and tuning, error Maintenance
Maintenance
corrections
Chapter 2 © 2007 by Prentice Hall 10
Prototyping Database Methodology
(Figure 2.6)
Chapter 2 © 2007 by Prentice Hall 11
Prototyping Database Methodology
(Figure 2.6) (cont.)
Chapter 2 © 2007 by Prentice Hall 12
Prototyping Database Methodology
(Figure 2.6) (cont.)
Chapter 2 © 2007 by Prentice Hall 13
Prototyping Database Methodology
(Figure 2.6) (cont.)
Chapter 2 © 2007 by Prentice Hall 14
Prototyping Database Methodology
(Figure 2.6) (cont.)
Chapter 2 © 2007 by Prentice Hall 15
CASE
Computer-Aided Software Engineering
(CASE)–software tools providing automated
support for systems development
Three database features:
Data modeling–drawing entity-relationship
diagrams
Code generation–SQL code for table creation
Repositories–knowledge base of enterprise
information
Chapter 2 © 2007 by Prentice Hall 16
Figure 2-8 Developing the three-tiered architecture
Chapter 2 © 2007 by Prentice Hall 17
Figure 2-9 Three-tiered client/server database architecture
Chapter 2 © 2007 by Prentice Hall 18