Handouts

Chapter 2: The Database Development Process

Enterprise Data Model

* First step in database development

* Specifies scope and general content

* Overall picture of organizational data at high level of abstraction

* Entity-relationship diagram

* Descriptions of entity types

* Relationships between entities

* Business rules

* Enterprise data model describes the high-level entities in an organization and the relationship between these entities

Information System Structure

* Conceptual blueprint for organization’s desired information systems structure

* Consists of:

* Data (e.g. Enterprise Data Model–simplified ER Diagram)

* Processes–data flow diagrams, process decomposition, etc.

* Data Network–topology diagram (like Fig 1-9)

* People–people management using project management tools (Gantt charts, etc.)

* Events and points in time (when processes are performed)

* Reasons for events and rules (e.g., decision tables)

Information Engineering

* A data-oriented methodology to create and maintain information systems

* Top-down planning–a generic IS planning methodology for obtaining a broad understanding of the IS needed by the entire organization

* Four steps to Top-Down planning:

* Planning

* Analysis

* Design

* Implementation

Information System Planning

* Purpose–align information technology with organization’s business strategies

* Three steps:

1. Identify strategic planning factors

2. Identify corporate planning objects

3. Develop enterprise model

Identify Strategic Planning

* Organization goals–what we hope to accomplish

* Critical success factors–what MUST work in order for us to survive

* Problem areas–weaknesses we now have

Identify Corporate Objects

* Organizational units–departments

* Organizational locations

* Business functions–groups of business processes

* Entity...