• Questionnaires: free format or fixed format.
The Database System Development Lifecycle DMA: The Database System Development Lifecycle 2
1 The software crisis
Last few decades there has been a rapid increase in software applications, many requiring
constant maintenance involving:
• correcting faults,
• implementing new user requirements,
• modifying software to run on new or upgraded platforms.
Effort spent on maintenance of software began to absorb resources at an alarming rate. As a
result, many major software projects were:
• late,
• over budget,
• unreliable,
• difficult to maintain,
• performed poorly.
Major reasons for failure of software projects include:
• lack of complete requirements specification,
• lack of appropriate development methodology,
• poor decomposition of design into manageable components.
2 The information system lifecycle
Solution was to propose a structured approach to software development called information
systems (IS) lifecycle or software development lifecycle (SDLC). Resources that enable
collection, management, control, and dissemination of data/information throughout an
organisation. Database is fundamental component of an information system (IS).
Development/usage should be viewed from perspective of the wider requirements of the
organisation. Structured approach to development of the database component of an IS is
required.
3 Fact finding techniques used in database system development
lifecycle
• Examining documentation: memos, organisational charts, training manuals, 4 Early milestones during database system development lifecycle
• Interviewing: structured or unstructured, • Database planning: mission statement, mission objectives,
• Observation: participatory/non-participatory, • System definition: system boundary, user views,