1 / 11

Database Development Process: Ensuring Coordination and Efficiency

This chapter highlights the importance of coordinating database development with other activities in an information system. It covers enterprise data modeling, information systems architecture, information engineering, top-down planning, and information systems planning. It also explores the database development process, system development life cycle, and alternative IS development approaches.

jfranks
Download Presentation

Database Development Process: Ensuring Coordination and Efficiency

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related