The Database Development Process 1 Incremental Commitment in

The Database Development Process 1

Incremental Commitment in DB Development § Project is reviewed at the end of each development phase (iterative process) § Re-justify the process under the light of new requirements and available resources § Requirements are tend to change all the time § Renew commitment of stakeholders § Change of budget by top management § Continue / Revise Scope / Cancel

Database Development Process Feasibility Study of Project Purpose – preliminary understanding Deliverable – request for project Requirement Analysis Conceptual Design Logical Design Physical Design - Is the project worth looking at ? - Is the DB system worth building? Implementation Maintenance

Database Development Process Feasibility Study of Project Requirement Analysis Purpose: state business situation and possible solution Deliverable: identify all the necessary BRs Conceptual Design Logical Design Physical Design • What do users need and want from the new system? • What the new system must do. Implementation Maintenance

Database Development Process Feasibility Study of Project Requirement Analysis Purpose: thorough analysis Deliverable: conceptual data model based on refined BRs (bi-directional) Conceptual Design conceptual data model Logical Design - next slide - example model from the web page Physical Design Implementation Maintenance

Conceptual Data Model

Database Development Process Feasibility Study of Project Purpose: information requirements structure Deliverable: Selection of DB system Requirement Analysis Conceptual Design Logical Design 1. Hierarchical DB Physical Design 2. Network DB 3. Relational DB 4. Object Oriented DB 5. No. SQL (Big Data) DB Implementation Maintenance

Database Development Process Purpose: develop technology specs Deliverable: program/data structures, DB technology purchases… Feasibility Study of Project Requirement Analysis Conceptual Design Logical Design Physical Design • Define physical organization and details of data Implementation Maintenance

Database Development Process Purpose: testing, training, debugging, installation, documenting Deliverable: operational programs, documentation, training materials Feasibility Study of Project Requirement Analysis Conceptual Design Logical Design Physical Design Implementation Maintenance

Database Development Process Feasibility Study of Project Purpose –monitor, repair, enhance Deliverable – periodic audits Requirement Analysis Conceptual Design Logical Design Physical Design Implementation Maintenance

DB Development Schedule Gantt Chart shows time estimates of tasks

DB Development Schedule … PERT Chart shows dependencies between tasks