Database Management
Systems
Subject Teacher: Zartasha Baloch
2
Database Development Process
Lecture # 3
Disclaimer: The material used in this presentation to deliver the lecture i.e., definitions/text and pictures/graphs etc.
does not solely belong to the author/presenter. The presenter has gathered this lecture material from various sources on
web/textbooks. Following sources are especially acknowledged:
1. Connolly, Thomas M., and Carolyn E. Begg. Database systems: a practical approach to design, implementation, and management. Pearson
Education, 2005.
2. 2. Hoffer, Jeffrey A.,Venkataraman Ramesh, and Heikki Topi. Modern database management. Upper Saddle River, NJ: Prentice Hall,, 2011.
In this Lecture you will Learn about:
Database Development Process
System Development Life Cycle
Prototyping Database Methodology
4
Database Development Process
It is the subdivision of the development process into a series of phases, or steps,
each of which focuses on one aspect of the development.
The collection of these steps is sometimes referred to as a System Development
Life Cycle (SDLC).
The SDLC is a complete set of steps that a team of information systems
professionals, including database designers and programmers follow in an
organization to specify, develop, maintain and replace information systems.
Systems Development Life Cycle (cont.)
Planning
Analysis
Logical Design
Physical Design
Implementation
Maintenance 5
Systems Development Life Cycle (cont.)
Planning
Planning
Purpose–preliminary understanding
Analysis Deliverable–request for study
Logical Design
Physical Design
Database activity– Implementation
enterprise modeling and
early conceptual data
Maintenance
modeling
6
7
Systems Development Life Cycle (cont.)
Purpose–thorough requirements analysis and
Planning structuring
Deliverable–functional system specifications
Analysis
Analysis
Logical Design
Physical Design
Database activity–Thorough and Implementation
integrated conceptual data
modeling
Maintenance
Systems Development Life Cycle (cont.)
Planning
Purpose–information requirements elicitation
and structure
Analysis
Deliverable–detailed design specifications
Logical Design
Logical Design
Physical Design
Database activity– Implementation
logical database design
(transactions, forms,
Maintenance
displays, views, data
integrity and security)
8
Systems Development Life Cycle (cont.)
Planning
Purpose–develop technology and
organizational specifications
Analysis Deliverable–program/data
structures, technology purchases,
organization redesigns
Logical Design
Physical Design
Physical Design
Database activity– Implementation
physical database design (define
database to DBMS, physical
Maintenance
data organization, database
processing programs)
9
Systems Development Life Cycle (cont.)
Planning Purpose–programming, testing, training,
installation, documenting
Analysis Deliverable–operational programs,
documentation, training materials
Logical Design
Physical Design
Database activity–
database implementation, Implementation
Implementation
including coded programs,
documentation, Maintenance
installation and conversion
10
Systems Development Life Cycle (cont.)
Planning
Purpose–monitor, repair, enhance
Analysis Deliverable–periodic audits
Logical Design
Physical Design
Database activity–
database maintenance, Implementation
performance analysis
and tuning, error Maintenance
Maintenance
corrections
11
Prototyping Database Methodology
12
Prototyping Database Methodology 13
Prototyping Database Methodology 14
Prototyping Database Methodology 15
Prototyping Database Methodology 16
