Database Life Cycle (DBLC)

Database Life Cycle (DBLC)

1. DB initial study

   • DB design
     • Implementation and loading
       • Testing and evaluation
         • Operation
           • Maintenance and evaluation
     • Purpose
       • Create the conceptual design
       • DBMS software selection
       • Create the logical design
       • Create the physical design
   • Designer
     • Called in
       • Current system failed to perform functions deemed vital by company
     • Examines current system operation
     • Must determine how and why current system fails
       • Time talking with/listening to end users
     • Must be excellent communicators and finely tuned interpersonal skills
     • Could be a lone operator or part of a systems dev team
   • Purpose
     • Analyze the company situation
     • Define problems and constraints
     • Define objectives
     • Define scope and boundaries
   • Analysis of the company situation
     • Definitions of problems and constraints
       • Read and understand "Define Problems and Constraints" on p. 520-521 of book
       • Database system specifications
         • See p.521 for more details
         • Objectives
           • Scope
             • Boundaries
     • Design must satisfy:
       • Company objectives
         • What is the organization's mission within the operating environment
         • Company Operations
           • What is the organization's general operating environment.
           • Company Structure
             • What is the Organization's structure? Knowing who controls what and who reports to whom is quite useful when trying to define required information flows, specific report and query formats, etc.