Explain the stages and their examples of database development lifecycle (DBMS)?

Let’s see the stages of database system life cycle (DDLC) and their facts using tabular form −

Stage of Database system development Lifecycle	Example of Facts	Example of Documentation Produced
Database Planning	Aims and objectives of database projects.	Mission statements and objectives.
System Identification	Description of major user views (Job roles, business application areas).	Definition of scope and boundary of database system, definition of user views to be supported.
Requirements Collection and Analysis	Requirements of user views, system specifications, including performance and security requirements.	User requirement specification, system specification.
Database design	User’s responses to checking the logical database design, functionality provided by target DBMS.	Logical database design, data dictionary, physical database design.
Application Design	Users’ response to checking interface design.	Application design.
DBMS Selection	Functionality provided by target DBMS.	DBMS evaluation
Prototyping	User response to prototype.	Modified user requirement specification and system specification.
Implementation	Functionality provided by target DBMS.
Data conversion and loading	Format of current data, data import capability of target DBMS.
Testing	Test Results.	Testing strategies used,
Operational maintenance	Performance testing results, new or changing user and system requirements.	User manual, analysis of performance results, modified users requirements and system specification.

Published on 06-Jul-2021 15:21:25