1 / 12

The Database Development Process

The Database Development Process. 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

annv
Download Presentation

The Database Development Process

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. The Database Development Process

  2. 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

  3. 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

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

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

  6. Conceptual Data Model

  7. Database Development Process Feasibility Study of Project Purpose: information requirements structure Deliverable: Selection of DB system Requirement Analysis Conceptual Design Logical Design • Hierarchical DB • Network DB • Relational DB • Object Oriented DB • NoSQL (Big Data) DB Physical Design Implementation Maintenance

  8. 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 Implementation • Define physical organization and details of data Maintenance

  9. 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

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

  11. DB Development Schedule Gantt Chart shows time estimates of tasks

  12. DB Development Schedule … PERT Chart shows dependencies between tasks

More Related