Chapter 2 The Database Development Process Outline n

Chapter 2 The Database Development Process

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

Enterprise Data Modeling First step in database development. n Scope and general content of organizational databases are specified. n

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

Information Engineering A formal top-down methodology n Uses data-orientation n To create and maintain IS n

Top-Down Planning n IS planning methodology that attempts to gain a broad understanding of the information system needs for the entire organization

Information Systems Planning n n 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.

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

Alternative IS Development Approaches Prototyping CASE and Repository

Managing People in DB Development System Analysts Database Analysts Users Programmers Database and data administrators Technical Experts – Networking, OS

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