The Database Development Process

1
Chapter 2

• The Database Development Process

2
Outline

• This chapter emphasizes the need to coordinate
  database development with all other activities of
  a complete information system.

3
Enterprise Data Modeling

• First step in database development.
• Scope and general content of organizational
  databases are specified.

4
Information Systems Architecture

• A conceptual blueprint for the structure of IS in
  organizations.
• Data
• Processes
• Network
• People
• Events and points in time when the processes take
  place
• Reasons for events Business rules

5
Information Engineering

• A formal top-down methodology
• Uses data-orientation
• To create and maintain IS

6
Top-Down Planning

• IS planning methodology that attempts to gain a
  broad understanding of the information system
  needs for the entire organization

7
Information Systems Planning

• Identifying strategic planning factors.
• Identifying corporate planning objects
  Organizational units and locations.
• Developing an enterprise model.
• Functional decomposition is the process of
  breaking down the functions of an organization
  into increasing level of detail.

8
Database Development Process

• System Development Life Cycle
• Enterprise Modeling
• Conceptual Data Modeling
• Logical Database Design
• Physical Database Design and Definition
• Database Implementation
• Database Maintenance

9
Alternative IS Development Approaches

• Prototyping
• CASE and Repository

10
Managing People in DB Development

• System Analysts
• Database Analysts
• Users
• Programmers
• Database and data administrators
• Technical Experts Networking, OS

11
Three Schema Architecture

• Conceptual Schema technology independent
  specification of the overall structure of a
  database ER Modeling, OO Modeling
• External Schema relational databases,
  normalization
• Physical Schema Indexes, Storage